The two ways I know about to import Dbs are;
1- Access has an upsizing wizard, but I've never used it myself.
2- The Enterprise manager has an import Wizard that will walk you through
importing a new DB into SQL. Access is one of the import types.
As far as linking them It's no doubt possible but between SQL and Access I'm
not sure.
Hope that helps.
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
Office: 909-943-8428
www.billtracker.org <http://www.billtracker.org>
-----Original Message-----
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 6:32 AM
To: CF-Talk
Subject: SQL server question
I'm not sure if this is the right list to post for this question, but here
it
goes.
We have a database that we're converting from Access to SQL server 7, and
since I'm new to this there are 2 issues as of now.
1. Can you set up a link (or alias I guess) that would link the old table
name from Access to the new one in SQL server? How do you do it?
2. How do you link a database on one machine with a database on another
machine (both are SQL server databases)?
Any help is appreciated.
Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
