Querying Excel File using ADO.NET

[Ann Marinas]

Hi all!

I'm trying to create a program that would extract data from an excel
spreadsheet through System.Data.OleDB.

I was wondering...

1. When creating a query from an excel spreadsheet, do I need to put the
exact sheet name?

2. Is there any possible way of dynamically getting the name of the excel
sheet first before querying it?

Thanks a million!

-A

 

[William Ryan]

Here's a quick article on how to do it
http://www.knowdotnet.com/articles/exceldatasource.html
1) AFAIK you do need the Table name to specify the query..
2) I think the GetOleDbSchemaTable will give you the info
http://www.knowdotnet.com/articles/getoledbschematable.html
about the Sheet names...

HTH,
Bill

 

[Ann Marinas]

Thank you so much! It helped! Really do appreciate it!