How to import Excel data using SQL Query (without wizard)?

Question

Say I have thousands of Excel files with all people's information.

Name Height
John  182
Sam   178
...

If I want to import these data into a new MS-SQL database table using SQL query, how should I do that?

Name  Weights
John  130
Sam   160
...

And now if I want to append 'Weights' data into previous table using query, how should I do that?

The reason I'm doing this is because import too much Excel using wizard can lead to a huge waste of time, so I'm thinking if I can embed SQL query in MATLAB, then a for loop will do the job for me, hopefully.

Thank you in advance.

Squirrel · Accepted Answer · 2016-11-13 06:34:33Z

1

you can use OPENROWSET to import from excel into table

example :

INSERT INTO yourtable ( . . . )
SELECT  . . . 
FROM    OPENROWSET('Microsoft.ACE.OLEDB.12.0',
        'Excel 12.0;Database=C:\EXCEL\ExcelFile.xlsx', 
        'SELECT * FROM [Sheet1$]')

answered Nov 13, 2016 at 6:34

Squirrel

24.8k5 gold badges41 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

How to import Excel data using SQL Query (without 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