SQL 2K - DTS

I got a packge to load from Excel sheet to database table. This Excel file
got many sheets and I have to just read from one of the sheet BUT it is
hidden.
Any links or tips for a VB script to create a name range for one of the
sheet.

Thanks
Jeff

Hi

I am not sure about the hidden sheet, buit this may help
http://www.sqldts.com/default.aspx?243

John
"MS User" <sqlman (AT) sql (DOT) com> wrote

Do you know the name of the named range/worksheet?

If you do then you can query it like this

SELECT [Sheet1$].*
FROM [Sheet1$]



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"MS User" <sqlman (AT) sql (DOT) com> wrote