Posted by ELINTPimp on 08/03/07 15:19

On Aug 3, 11:04 am, Vik Rubenfeld <v...@mindspring.com.invalid> wrote:
> Is there a way to import an MS Access database .mdb file into MySQL
> running locally on a Mac?
>
> Thanks in advance to all for any info.

This really isn't a PHP question, nor is it really a Mac-specific
problem. I will answer the question anyway, since I'm getting wings
for lunch and am therefore happy.

In my experience, the easiest way to import data from db to db is a to
dump the data in a delimited format and import into the new database.

http://dev.mysql.com/doc/refman/4.1/en/mysqlimport.html

There are articles out there about how to do it directly from Access
to MySQL...
http://www.google.com/search?source=ig&hl=en&q=mysql+import+data

But, like I said, I personally like dump and pull since I work on so
many different DB types.

[Back to original message]