I created a MSSQL server database called "archives" in a
network server machine called "BAA"

I have one archive.mdb file in my local C drive (MS 2000
professional) with MSSQL server loaded.

I open the MSSQL in my local laptop and connect the "BAA"
and see the "archives",

1) then I use import data function,
2) Choose Source as ACCESS, and find local archive.mbd
3) choose destination as BAA MS OLE DB provider for SQL
4) click finish
5) system message "successfully copied 11 (tables) from
MS Access to MS SQL.
Now question:
I can't find the these 11 tables inside
database "Archives" of the "BAA" server?

Where are these tables? Which step I did wrong?

Thanks in advance

In article <0ec301c36803$6434fa50$a601280a (AT) phx (DOT) gbl>, d <ddu (AT) csmius (DOT) com>
writes
Your description does not mention setting the destination database.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com