I am importing data from Excel files with multiple worksheets.

When you use the DTS dialog for the Data Pump object, the Source tab has a
dropdown box with all the available worksheets in a given Excel file.

I want to access this list of worksheet names without having to resort to
Office automation of Excel. How can I access this list programatically?

Thru the Disconnected Edit I can see a SourceObjectName property but this
only references the currently selected worksheet. I need to iterate through
each worksheet in the given file, so I need access to this list.

AFAIK DTS simply goes through the driver and makes the request. It must
request this from something exposed by the driver.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Jamie Carper" <JamieCarper (AT) discussions (DOT) microsoft.com> wrote

I suspected as much. Is there a way to tap into this exposed service?

In my case that would be the Microsoft Jet OLEDB 4.0.

"Allan Mitchell" wrote: