Openrowset but select only specific columns from file

Question

Hoping there is a way to do this, I want to use open row set to select only specific columns from a file that has many more than what I need. I'm trying to do the below but getting an error on the FROM clause.

 `INSERT INTO TestData ([Column1],[Column2])
    FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=C:\test.xlsx;', 
    'SELECT [Column1],[Column2] FROM [Sheet1$]')`

Msg 156, Level 15, State 1, Line 50 Incorrect syntax near the keyword 'FROM'.

MGilbert · Accepted Answer · 2022-10-11 18:58:36Z

2

It should be this way:

INSERT INTO TestData (
[Column1],
[Column2])
SELECT
[Column1],
[Column2]
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=C:\test.xlsx;','SELECT * FROM [Sheet1$]')

answered Oct 11, 2022 at 18:58

MGilbert

411 silver badge4 bronze badges

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

Collectives™ on Stack Overflow

Openrowset but select only specific columns from file

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