Hello! Does anyone know if it is possible to update and store data from MS Excel to MS SQL Server database? I am already inserting the data into Excel from the same db, but I want to know if after modifications are made to the data can they be updated to the db from Excel? Any help would be greatly appreciated.

*******(*)*******

__________________
*******(*)*******

are you using a linked server or are you using dts import the excel data?

Hi! Thank you for your reply, I really appreciate it. Currently the server is linked (local) I am not using DTS although I've thought about and actuallly tried it, but for some reason it did not update any changes that were made on the Excel sheet in the DB

*******(*)*******

Can accomplish your task with SQL 2000 DTS.

A few questions first.

You mention that you are exporting the data from SQL, are you creating the excel file or appending data?

1.What you can do is use DTS to export you data to excel
2.Update your excel file
3.Drop and recreate your sql table and import from excel
This can all be done in one DTS package.

The second option is using DTS and Visual Basic ActiveX Script

http://www.sqldts.com/default.aspx?243

Suggestion: Move your question to the SQL Server DTS and you may receive additional information.

I am appending the data from SQL to an previously created Excel worksheet. I am also using C# for the code. I tried using the DTS wizard, but it did not work or I did not configure it correctly.

Is there a way to move the question and responses to another forum? Or, do I repost it?

thanks for your help

*******(*)*******