Update SQL from Excel

[goofy78270]

I am not sure if this is the right section to place this, so I hope someone can help.


I have built a spreadsheet that reads in a SQL table and then does some manipulation on the data. Now, I want to replace the current data in the table with this newly created data within excel. There is not a function to export data like the import, so I am a bit lost.

 

[SydneyGeek]

Do you want to *update existing records* or do you want to *replace* them with new records?

Also, is this SQL Server or another source?

Denis

 

[goofy78270]

I would like to update existing records. I am looking to do something like:

IF field1 = sheet1!A1 then
Update table1
field2 = sheet1!B1