On Mar 18, 9:27 pm, Ant <A...@discussions.microsoft.com> wrote:
> Hi, I'm a Newbie to DTS who needs to import data from an excel spreadsheet
> into SQL2000.
>
> When I use the import Wizard, the tables to be imported (sources) include
> all the pages from the excel spreadsheet as expected, however an extra source
> for each page is shown with the same name plus a $ sign. e.g.
>
> Customer
> Customer$
> Sales
> Sales$
>
> What do I do with this extra source? Do I just ignore it or should I incude
> it by ticking it?
>
> Many thanks for any ideas on this.
>
> Ant

"EMartinez" wrote:

> On Mar 18, 9:27 pm, Ant <A...@discussions.microsoft.com> wrote:
> > Hi, I'm a Newbie to DTS who needs to import data from an excel spreadsheet
> > into SQL2000.
> >
> > When I use the import Wizard, the tables to be imported (sources) include
> > all the pages from the excel spreadsheet as expected, however an extra source
> > for each page is shown with the same name plus a $ sign. e.g.
> >
> > Customer
> > Customer$
> > Sales
> > Sales$
> >
> > What do I do with this extra source? Do I just ignore it or should I incude
> > it by ticking it?
> >
> > Many thanks for any ideas on this.
> >
> > Ant
>
> Are you using the exact same column names/mappings?
>
> Enrique Martinez
> Sr. SQL Server Developer
>