Copying Access DB to SQL Server 2000

[Ken]

Is there a way to copy an entire Access Database to Sql
Server? I have an extensive DB built in Access and need
to migrate to SQL Server but I don't want to rebuild all
the queries and macros.

 

[Van T. Dinh]

Use the Upsizing Wizard to upsize the Access Table to SQL Server Database
Table. Tony Toews has an article on this. Check his Web page:

http://www.granite.ab.ca/accsmstr.htm

 

[Len]

Is there a way to copy an entire Access Database to Sql
Server? I have an extensive DB built in Access and need
to migrate to SQL Server but I don't want to rebuild all
the queries and macros.

Ken, wwww.upsizewizard.com may have the answers you are looking for.

Len

 

[Tony Toews]

Ken, wwww.upsizewizard.com may have the answers you are looking for.

Please add a sig indicating that you are a representative of the
company for which you are posting. This way folks will realize that
you have a bias.

Don't get me wrong. We don't mind vendors posting answers directing
folks to their products. We just want folks to be up front about it.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm