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!