Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 writing to sql database from active excel

Author  Topic 

Yuka83
Starting Member

1 Post

Posted - 2009-07-24 : 12:37:30
hi all,

I'm trying to update table in sql database from excel sheet
without closing the excel file.

meanwhile i import from excel but have to delete the details from the table in SQL server first.

is there any way to update the table in SQL server from the Excel spreadsheet without closing it ?
my propose is to create automated update every 5 minutes..

any help will be appriciated!
   

- Advertisement -