looking for access 2000 to sql server 2000 sql/que

[tonyck]

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]

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