Export Access DB into SQL DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thomas - 23 Dec 2003 20:06 GMT

Can you export an Access Database into SQL? If you can how hard is it?

Reply to this Message

Van T. Dinh - 23 Dec 2003 22:18 GMT

You can use the Upsizing Wizard in Access.

Signature

HTH
Van T. Dinh
MVP (Access)

> Can you export an Access Database into SQL? If you can how hard is it?

Reply to this Message

Joe Fallon - 24 Dec 2003 05:35 GMT

Yes.
Not hard.

Oh.... you wanted some details?
1. Build the same table in SQL Server.
2. Link to it in Access.
3. Write a query and append the Access data to the new linked SQL Serve
table.

Signature

Joe Fallon
Access MVP

> Can you export an Access Database into SQL? If you can how hard is it?

Reply to this Message