dollar signs at the end of tables

Anyone know what's with dollar signs at the end of tables? One of my
clients has been "messing around" with his database, and I know he hasn't
got a clue. So now all the tables have been duplicated with the duplicates
having dollar signs at the end of the tables.
ex.
tblMytable
tblMytable$
Thanks,
JonIt's not actually my database, it's one of my clients, and I have absolutly
no idea what he did.
Thanks for the post though :-)
"Chinna Kondaveeti" <ckondaveeti@.hotmail.com> wrote in message
news:0d7201c36699$eaf99340$a001280a@.phx.gbl...
> I am not sure how they got in your database. But, usually
> when we export the excel workbooks using DTS, and if you
> choose the option create table and load the data, it will
> create a table with the worksheet name followed by $ (e.g.
> sheet1$ etc.)
> Thanks
> Chinna.
> >--Original Message--
> >Anyone know what's with dollar signs at the end of
> tables? One of my
> >clients has been "messing around" with his database, and
> I know he hasn't
> >got a clue. So now all the tables have been duplicated
> with the duplicates
> >having dollar signs at the end of the tables.
> >
> >ex.
> >
> >tblMytable
> >tblMytable$
> >
> >Thanks,
> >
> >Jon
> >
> >
> >.
> >|||May be MS access also puts duplicates, if you try to
connect to SQL Server database and try to save the tables.
Thanks
Chinna.
>--Original Message--
>Anyone know what's with dollar signs at the end of
tables? One of my
>clients has been "messing around" with his database, and
I know he hasn't
>got a clue. So now all the tables have been duplicated
with the duplicates
>having dollar signs at the end of the tables.
>ex.
>tblMytable
>tblMytable$
>Thanks,
>Jon
>
>.
>|||On Tue, 19 Aug 2003 17:39:03 -0400, "Jonathan Williams"
<anon@.covad.net> wrote:
>It's not actually my database, it's one of my clients, and I have absolutly
>no idea what he did.
>Thanks for the post though :-)
Hmm the further thought here would be... " have you actually asked him
what the f** he did?"
Al
>
>"Chinna Kondaveeti" <ckondaveeti@.hotmail.com> wrote in message
>news:0d7201c36699$eaf99340$a001280a@.phx.gbl...
>> I am not sure how they got in your database. But, usually
>> when we export the excel workbooks using DTS, and if you
>> choose the option create table and load the data, it will
>> create a table with the worksheet name followed by $ (e.g.
>> sheet1$ etc.)
>> Thanks
>> Chinna.
>> >--Original Message--
>> >Anyone know what's with dollar signs at the end of
>> tables? One of my
>> >clients has been "messing around" with his database, and
>> I know he hasn't
>> >got a clue. So now all the tables have been duplicated
>> with the duplicates
>> >having dollar signs at the end of the tables.
>> >
>> >ex.
>> >
>> >tblMytable
>> >tblMytable$
>> >
>> >Thanks,
>> >
>> >Jon
>> >
>> >
>> >.
>> >
>