looking for access 2000 to sql server 2000 sql/que

tonyck · Jul 7, 2005

Hi guyes . I am looing for a simple to use tool that easily convert th
access 2000 query or sql code to sql server 2000 code and visa versa
Thank

Graham R Seach · Jul 8, 2005

Tony,

Access has a wizard, the Upsizing Wizard, which may be sufficient for you.
Tools | Database Utilities | Upsizing Wizard.

But in case you don't find that sufficient:
http://www.ssw.com.au/ssw/UpsizingPro/

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

How to quickly change server source for Access Pass through queries.	1	Apr 22, 2009
Access 2000 ADP and SQL Server 2005	2	Jun 8, 2009
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine)	0	Apr 25, 2015
Data provider could not be initialized	1	May 31, 2012
Current User Problem	2	Aug 25, 2009
Access 2003 or 2007 Compatible with SQL Server 2008	6	Nov 19, 2008
Access 2007 can't connect to SQL Server	1	Jul 19, 2008
Upsizing to SQL Server	6	Feb 28, 2009

Ask a Question