get Excel table names

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Nikolay Petrov (johntup2_at_mail.bg)
Date: 02/27/05 

Date: 27 Feb 2005 09:32:47 -0800

I have to read data from MS Excel files and I use OLEDB reader for
that.
The problem I encounter is that I don't preliminary know the names of
the sheets in the Excel files, so I can include them in my connection
string.

Any way to do that?

TIA

Quantcast