RE: [cobalt-users] [RAQ4r] ASP, MySQL, and Microsoft Access

["Michael Tubbe" <mtubbe@xxxxxxxxxxx>]

> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Si Watts
> Ok, here's the deal.  I have and maintain a Microsoft
> Access Database on a web site.  I cannot however figure out how to
> convert my Access database to MySQL (or any other format other
> than Dbase 5)

I successfully converted a couple of ASP/Access sites to PHP/MySQL sites.
To convert the Access to MySQL, I used:

ftp://sunsite.dk/mirrors/mysql/Downloads/Contrib/exportsql.txt (version 2)

There seems to be a version 3 now:

http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt

but I haven't used it yet.

I remember there being a glitch in the version 2 script, but I worked around
it so it must not have been too big of a problem.

As I remember, you put the script in as macro in the Access DB.  When you
run it, it steps through the database and creates a "dump" text file in
MySQL format.  Once the dump is created, you just import into MySQL.  I used
phpMyAdmin for this, but I'm sure I've seen similar examples of importing
from the command line.  Check the archives.

--
Michael Tubbe