Importing existing data

J

John

Hi

In vs2005 beta2 I have created a sql server data file from within vs. Is
there
any way to import existing access tables & data into the sql server
datafile? I have tried installed sql server 2004 developer from msdn but did
not see any enterprise manager type tools that come with sql server 2000.
What am I missing?

Thanks

Regards
 
N

Norman Yuan

If you have MS Access2K or later, click "Tools->Database Utilities->Upsizing
Wiard".
If you have full SQL Server (or MSDE1.0, the older version, not MSDE2000),
"DTS Import/Export Wizard" should be a vailable through "Start->Program->Sql
Server/MSDE->Import and Export Data"
 
Top