EXCEL - getting sheet names

[Thomas]

Hi - I've managed to get an ole db provider to read information in
from an excel spreadsheet, but I have to include the sheet name in the
select statements. I was wondering if someone could help me by
explaining or showing some sample code of pulling in the sheet names
before running a select statement. I am having the user point to the
excel file with the OpenFileDialog component and then want to
dynamically populate a Combobox with the sheet names availabe in the
spreadsheet so the user can pick one. Can anyone please help?

 

[William Ryan eMVP]

Once you have your connection string set up, if you're using OleDb, I think
GetOleDbSchemaTable will work for you
http://www.knowdotnet.com/articles/getoledbschematable.html