Dave, Access has a migration wizard (I forget the name) built-in that will keep all keys and more.
--- Ben -----Original Message----- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:02 PM To: CF-Talk Subject: Importing tables - Access to SQLServer Whenever I import a table into SQL-Server from MS Access I always loose my primary keys. Is there a particular option in Enterprise Manager that I'm overlooking that preserves primary key fields? Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
