Importing existing data

  • Thread starter Thread starter John
  • Start date Start date
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
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing existing data 1
What are the steps to fix damaged MDF files in SQL Server? 0
Best way to move data from Access backend to SQL Server 3
32 bit access application and 64 bit SQL 2008 2
Data access, table data display in adp's. 4
Append Access Data to SQL Server Table 12
Data Entry Microsoft Access Project 3
How to link a Access FE to SQL Server BE 10

Back
Top