Well, the short answer to your question as you expressed it would be that
the name appended with the $ represents the worksheet, as opposed to the
named range with the same base name.

If you can use DTS to create a destination worksheet with a name like your
users want, and to export successfully, I'd script out that package as VB
and examine the generated code. You may want to check the "drop and
recreate" option to make sure you see the CREATE TABLE statement in the
code; otherwise it's just running at design time.

-Doug

--
Douglas Laudenschlager
Microsoft SQL Server documentation team
Redmond, Washington, USA

This posting is provided "AS IS" with no warranties, and confers no rights.

"alaspin" <anonymous (AT) discussions (DOT) microsoft.com> wrote