When I use the DTS wizard to import data into a SQL table only 3 out of 2050
records are imported and I get no error messages. When I select the SQL
table of the same name with a $ on the end I can preview the first 100
records and the import seems to succeed and show 2050 records are imported to
the table with the $ sign.

Any help would be appreciated.

The name WITH the $ is the worksheet. The name WITHOUT the $ is a named
range. You need to check the definition of the range in Excel...it may have
originally been created only to extend down those 3 rows, and never enlarged
when new data was added. As a very general rule, it may be safer to use the
worksheet name (with the $) unless you're confident that the current range
boundaries match the actual rows and columns used.

-Doug

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

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

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