Update database using data from Excel using SQL statement in SQL Server Import and Export Wizard

Question

I am trying to import data from a column in a .xslx file into a database. I'm using SQL Server 2008 and in the Import and Export Wizard I select the file and go to "Write a query to specify the data transfer". My knowledge of SQL is basic and am not sure how I can select the data from the file.

What is an SQL statement that selects a column from an Excel file and updates the database with it? (any corresponding values already in the database can be overwritten)

Rory Hunter · Accepted Answer · 2012-05-07 16:55:33Z

0

It would be easier to just get the wizard to create the table and load the data for you instead of writing the query. Have you tried that? Is there something specific that you need it to do? It may be easier to just get the data into the database in some form, then massage it into its final form.

answered May 7, 2012 at 16:55

Rory Hunter

3,5001 gold badge16 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update database using data from Excel using SQL statement in SQL Server Import and Export Wizard

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related