阅读背景:

动态地将Excel数据导入DataBase

来源:互联网 

how you can probably see by the title, I want to know a way to import data from excel to a database, even though I read a lot of questions and answers about this, I coundn't find one that would solve my problem. So my excel sheet is every minutes refreshing its numbers (by getting new values from the internet and overwriting the same cell), so the excel needs to be always opened. I want to read these values from visual studio, get these values and write it on my database. I already got that working using OleDb and writing it on PostgreSql, but it only works when my excel is closed (i think that is like that because OleDb opens excel to read it, and sice it is already opened, it doesnt work). I really appreciate anyone that could help me... Thanks!how you can probably see by the title, I want t




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: