Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion


Migrate access data to sql server.

By ananthap ·
I need to migrate some MS-Access 2000 (SP-1) databases to SQL server 2000 std edition.

Is it posibble to simply migrate the entire database? If not, I could also do it table by table?

I am new to SQL server and have some experience in MS-Access.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by JEPott In reply to Migrate access data to sq ...

Here's some info from Microsoft on doing this:;en-us;237980

Collapse -

by LeighX In reply to Migrate access data to sq ...

You will need to upsize your database from within access.
This is very easily done. open your DB and make sure tables under options is highlighted. Then Tools --->Database Utilities ---> Upsizing wizard. Then just follw the simple steps.

Related Discussions

Related Forums