General discussion

Locked

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.

end

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by JEPott In reply to Migrate access data to sq ...
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.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums