Get only specific columns from Excel (ACE OLEDB)

Question

I am using ACE OLEDB to load an excel file into a DataTable.

I have a list of the columns I need to grab from the file (column names).

Problem is I couldn't find any working source on how to get only those specific columns from the Excel into the DataTable.

score 5 · Accepted Answer · edited Jan 24 '17 at 18:25

5

You can query columns like you would any other SQL sentence:

SELECT [columnName1], [columnName2] FROM Sheet1

columnName should be the value in the header of the column that you are trying to get.

edited Jan 24 '17 at 18:25

maniak1982

answered Jan 24 '17 at 18:12

Damian Galletini

1

You may find that 'Sheet1' needs to also be in square brackets. – Alan B Feb 07 '18 at 11:18
How would I skip the first row below the header (empty row) in my SELECT? – timunix Mar 09 '21 at 09:05

1 Answers1