Reading specific columns from Excel

[Vipul Bhatt]

Dear All Normally the query used to read Excel file is "SELECT * FROM SHEET1$" Can anoyone help on how can we read specific columns using the query. For Eg. If we wan to read only columns C, D, and F then is there anything like "SELECT C, D, F FROM SHEET1$" Regards.

[Paul Conrad]

Has the thought occurred to you to go and look on MSDN? Have you tried:

Vipul Bhatt wrote:

SELECT C, D, F FROM SHEET1$

and what was the result?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

[Vipul Bhatt]

Getting an error "No value given for one or more required parameters." if any of the following queries are used. > SELECT C, D, F FROM SHEET1$ > SELECT COLUMN3, COLUMN4 FROM SHEET1$ And yes tried searching MSDN as well. The process is still on. Regards.

[rprateek]

To find your exact answer you can go to Read Excel File From VB application

Blog for Programmers