Access <->MySQL

[Bill]

Hi

I have a DB built with MsAccess that came with VB4 (Jet engine if I
remember) on a WindowsME machine.

Now I want to use that DB on Ubuntu with MySQL.

Is there a way to import the Access db in MySQL so I could store the
data in a MySQL db?

I don't have VB4 anymore so I can't write an export routine for that db.

Thanks

[J.O. Aho]

Here are a page from MySQL describing different methods to export/import the
ms-access data into MySQL.

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

There are quite many hits at google if you make a search there.
--

//Aho

[Luuk]

Bill schreef:

i think you should be able to access this with ODBC?

--
Luuk

[Michael Austin]

If you can access MySQL with ODBC - use linked tables and copy the data
over that way... I would manually set up the tables in MySQL so you can
create the PK etc... before copying the data.

[Bill]

J.O. Aho a écrit :

>> Is there a way to import the Access db in MySQL so I could store the
>> data in a MySQL db?
>

> http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

MDBviewer reads the db and produces a csv file. No need for any other
converter or odbc or anything.

Thanks to all who replied

[rob_mazur]

Another alternative....

In MS Access, export the data table(s) out in tab-delimited format.
Create the table(s) in MySQL and use the LOAD DATA command.

mysql> load data local infile 'path-to-my-delimited-data.txt' into
table mySQLTableName;

Rob