Web Development

Ask something
Discussion Locked

SQL to Access

0 helpful
5 replies

by corky132 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I know there's an import utility to import an Access database into SQL, but can you go the other way? (the database was originally converted from access.. no changes except record additions)..

thanks.

5 replies

by m&m

You are probably thinking of the upsizing wizard? You can accomplish the reverse (with some extra work) from Access linked to your Sql DB (the Access version of select into is a make table query to recreate the Sql tables locally, and populate them)or you may create a DTS package(s) for the purpose for example (from MS Sql Server Enterprise Manager). Other than that, there are a variety of third party options that I cannot comment on one way or the other. (You would need to convert your SP s, to queries and make a note of what is indexed and your defaults, triggers, etc. and redo those in Access if you go with the Access with links or DTS routes).

by andrew

The DTS wizard in SQL Server should work for you.

Right-click on the database in Enterprise Manager and select 'Export' from the context menu.

You might still need to do some tweaking.

This discussion is closed to new replies.