MyAccess2000

ravijp — Tue, 14 Aug 2001 04:23:26 +0000

This is a tool which lets you import Access 2000 tables into MySQL.

I've used it extensively.

Works great, but has a nag screen which pauses the entire interface for 10 seconds every so many minutes. It can be gotten rid of by paying a few $$s.

This is where you can find the s/w :
http://www.mysql.com/downloads/os-win32.html

Regarding changes to your code, if the code is object oriented, then by just changing the code pertaining to the db access (drivers etc) from Access to MySQL should take care of your situation.

I'm a Java/PHP/Perl specialist. So, I don't know too much about ColdFusion.

My 3.5 cents...

Ravi

Adrian J. Moreno — Wed, 25 Jul 2001 19:59:07 +0000

Check out http://www.mysql.com for more info. Here's a direct link to db converters - http://www.mysql.com/doc/S/E/SEC583.html

There are two in particular to check out:
exportsql.txt and access_to_mysql.txt. The first one is more configurable from the description.

As for the CF scripts, you shouldn't have too hard a time. You might have some small SQL syntax to change, but the rest should be fine. However, is your friend used instead of INSERT INTO for sql queries you may have some work ahead of you. It's much worse converting from SQL Server to mySQL.

A great resource I keep close at hand is O'reilly's SQL in a Nutshell. It has all the datatype differences of the commons dbs as well as syntax differences.

Peter J. Boettcher — Thu, 28 Jun 2001 12:43:22 +0000

I'm don't know for certain, but I would think that mySQL includes filters for importing data from other sources. At the very least it should be able to import from a text file. So you could save your Access database as a text file and import it that way.

As for the CF scripting, there will have to be some changes, but it shouldn't have to be rewritten entirely.