How do you Update a Field in an SQL table using Data from Excel

Question

How do you Update a Field in an SQL table using Data from Excel

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

One way to achieve it could be to import your excel file into a table and the update the fields in the destination table.

If you want something more complex, try taking a look at SSIS (SQL Server Integration Services).

Regards

Gianluca

-- Gianluca Sartori

Steve Jones - SSC Editor SSC Guru Points: 739545 More actions · Answer 2

I'd go with something like Gianluca's idea. SSIS or import to a table.

dmc-608719 SSCarpal Tunnel Points: 4663 More actions · Answer 3

I would agree that creating an SSIS package to import the excel and using that imported table as the source is probably the best option. A less secure option is the OPENROWSET() commands to open it on the fly and query directly from the file.