Home > Archive > MySQL ODBC Connector > September 2005 > converting access (.mdb) files...









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author converting access (.mdb) files...
Craig Hoffman

2005-09-15, 8:24 pm

Anyone know a way to convert MS Access DB files (.mdb) into a format
MySQL can import? I'm on a Mac hence I don't have Access.

Best,
CH
____________________
___
Craig Hoffman
www.eclimb.net

choffman@eclimb.net
iChat / AIM: m0untaind0g
____________________
___




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Subscriptions

2005-09-15, 8:24 pm

There used to be a program called "AccessDump" that will dump access tables
into .sql files. Their website seems to be unresponsive at the moment,
though.

Here's a link:
www.AccessDump.com

They are from the south, so it's possible that the site was affected by the
hurricane.

Jenifer





----- Original Message -----
From: "Craig Hoffman" <choffman@eclimb.net>
To: "MySQL" <mysql@lists.mysql.com>
Sent: Thursday, September 15, 2005 4:52 PM
Subject: converting access (.mdb) files...


> Anyone know a way to convert MS Access DB files (.mdb) into a format
> MySQL can import? I'm on a Mac hence I don't have Access.
>
> Best,
> CH
> ____________________
___
> Craig Hoffman
> www.eclimb.net
>
> choffman@eclimb.net
> iChat / AIM: m0untaind0g
> ____________________
___
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql? unsub...sitecenters.com
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Remo Tex

2005-09-16, 3:24 am

Perhaps you could try "MySQL Migration Toolkit"
http://dev.mysql.com/downloads/migr...oolkit/1.0.html
still beta though...
NB!
ATTENTION: Before installing the MySQL Migration Toolkit please download
and install the Java 5.0 or 1.4.2 Runtime Environment (JRE) from
http://java.sun.com

NOTICE: If you want to use the MySQL Migration Toolkit with Oracle
please make sure to attach the Oracle JDBC driver (ojdbc14.jar) by
selecting the main menu item [Tools] > [Attach JDBC Driver]. A typical
location of that file on Windows would be 'C:\Oracle\ora92\jdb
c\lib'.

Craig Hoffman wrote:
> Anyone know a way to convert MS Access DB files (.mdb) into a format
> MySQL can import? I'm on a Mac hence I don't have Access.
>
> Best,
> CH
> ____________________
___
> Craig Hoffman
> www.eclimb.net
>
> choffman@eclimb.net
> iChat / AIM: m0untaind0g
> ____________________
___
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Karam Chand

2005-09-18, 11:23 am

If you can catch hold of a windows box then there is
tool called SQLyog that has a great migration tool.

I was able to import a clients MDB database with all
the FKs directly from Access to MySQL. You dont need
to go thru Access -> Script -> MySQL.

You can download it from http://www.webyog.com

Karam

--- Craig Hoffman <choffman@eclimb.net> wrote:

> Anyone know a way to convert MS Access DB files
> (.mdb) into a format
> MySQL can import? I'm on a Mac hence I don't have
> Access.
>
> Best,
> CH
> ____________________
___
> Craig Hoffman
> www.eclimb.net
>
> choffman@eclimb.net
> iChat / AIM: m0untaind0g
> ____________________
___
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>

http://lists.mysql.com/mysql? unsub...br /> yahoo.com
>
>





____________________
______________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com