Howdy, I am trying to import an Access 2000 database into MS SQL 2000 using the DTS wizard in MSSQL. This is the first time I've attempted something like this as I've only recently started using MSSQL.
The main Access database has lots of linked tables scattered across 11 other Access databases. When I ran the DTW wizard in Enterprise Manager, it grabbed only the tables that were in the main Access database. Is it possible to import all of the linked tables at the same time? If so, how? TIA. Chris Montgomery monty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
