Selecting sheets when importing from Excel with the wizard -- sql server dts

Conan Kelly
2/2/2007 6:17:53 PM

Hello all,

When ever importing from Excel using the Import/Export Wizard, when you get
to the part where you select the sheets you want to import, what shows up in
the list is something like:

'[1st Sheet Name]$'
'[1st Sheet Name]$_'
'[2nd Sheet Name]$'
'[2nd Sheet Name]$_'
....etc

What is the difference between '[1st Sheet Name]$' and '[1st Sheet Name]$_'

Thanks for any help anyone can provide,

Conan Kelly

Allan Mitchell
2/2/2007 11:05:38 PM

I think one of them is the name of the sheet itself and one is the name
of the named range associated with the sheet.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Selecting sheets when importing from Excel with the wizard