[Modus] convert to sql from access

[Jim Barstow]

Title: Message

With a little more detail, are you talking about an extended auth database, quarantine, or what?

 

I have a DTS package I wrote to do this, it was quite simple and only imported a handful of fields from the Access EXT DB to the SQL EXT DB.

 

Unfortunately, I dont know if there is a way to export or save a DTS transaction for you to use.  I simply added an access object, an sql object, and setup data transformations for the fields I needed to copy. Took all of about 10 minutes, maybe 30 for the amature DTS builder.

 

Sr. Network Engineer
Diversified Solutions and Services, Inc.

22645 Canal Road, Suite B

Orange Beach, AL 36561

(251)980-8968

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael B. Smith
Sent: Monday, January 19, 2004 9:42 AM
To: [EMAIL PROTECTED]
Subject: [Modus] convert to sql from access

Does anyone have a script/process/whatever to convert from access/mdb to sql/odbc?

 

(I have the script to create the tables, I'm talking about a way to import the old data into the new DB.)

 

Thanks.