Showing posts with label databasewith. Show all posts
Showing posts with label databasewith. Show all posts

Monday, March 19, 2012

creating SQL from ACCESS

what is the best way to create a MS SQL 2000 database from an existing MS ACCESS 2003 database

with all datas in it ?

thank youUpsizing Wizard in Access (Tools/database Utilities)

DTS in Enterprise Manager (right click, All tasks, Import Data as I recall).