unable to get the data updated in sql server from excel

[nnaveen646]

kindly help 

i have an excel file which is having certain data in its cells. this data gets updated automatically every sec. now i have written a code in module which establishes the connection to sql server and inserts the data into a sql table in it.

now the issue is the data is not getting refreshed in the SQL table which is getting updated...

[#2]

Do you get any error message from your code that is supposed to refresh the data in SQL Server? Does the code get called?

[#3]

@nnaveen646 If you're connecting to sql and inserting a record every second, that may be the problem - some resources not getting released, or too many records for that table/db. Check database log for errors too.