Querying an Excel File

[itsdaway]

Hi there everyone. I believe I have a fairly simple question, but cannot find an answer out there.

I have a .NET application that connects to an excel file using an oledb driver. With this, I can query the excel file quite easily based on the column headers in the file.

What I need to be able to do now is query the first row in the Excel file, to return the column headers. Is there a way to query a specific row?

I'm also wondering how I can query the excel file for the different worksheets within it. Anyone know where I can go to research further?

Thanks for any and all help.

[itsdaway]

nobody has ever tried this?

[itsdaway]

last bump....