MS Access => MySQL

[DD]

hi there,

I don't think it's possible, but I'll try the question.

A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql? I googled
the whole web. You are my last hope

Thanks in advance.

Arjen

[Ed Seedhouse]

On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <[e-mail]> wrote:

I don't think it's possible, but I'll try the question.

A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql? I googled
the whole web. You are my last hope

In general no. To read Access databases you need Access, which is a
Windows product. However, if you have a copy of Office on CD you can
get the Crossover Office product (www.codeweavers.com), which is a
version of "wine" that will run office products, including Access.
You can get a 30 day trial version for free. You'll need to install
the product, then use it to install Office. I know it will read .mdb
files because it does on my system under RH 9. How good the support
is I cannot say because I haven't tested it extensively. It will read
the tables, however.

A simpler way would be to get your friend to export the tables to
Excell files. Open Office, which is installed by default with Red Hat
9 *can* read excell files. You can then export these files to your
mysql databases.

You cannot open access files with mysql - they are totally different
products with totally different approaches to database management.

Ed

[Marc Schwartz]

On Wed, 05 Nov 2003 14:09:16 +0000, Ed Seedhouse wrote:

On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <[e-mail]> wrote:

I don't think it's possible, but I'll try the question.

A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql? I
googled the whole web. You are my last hope

In general no. To read Access databases you need Access, which is a
Windows product. However, if you have a copy of Office on CD you can get
the Crossover Office product (www.codeweavers.com), which is a version of
"wine" that will run office products, including Access. You can get a 30
day trial version for free. You'll need to install the product, then use
it to install Office. I know it will read .mdb files because it does on
my system under RH 9. How good the support is I cannot say because I
haven't tested it extensively. It will read the tables, however.

A simpler way would be to get your friend to export the tables to Excell
files. Open Office, which is installed by default with Red Hat 9 *can*
read excell files. You can then export these files to your mysql
databases.

You cannot open access files with mysql - they are totally different
products with totally different approaches to database management.

Ed

You might want to try MDBTools:

http://mdbtools.sourceforge.net/

You can then access the Access tables and export the data from them.

HTH,

Marc Schwartz

[Ed Seedhouse]

On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <[e-mail]> wrote:

I don't think it's possible, but I'll try the question.

A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql? I googled
the whole web. You are my last hope

In general no. To read Access databases you need Access, which is a
Windows product. However, if you have a copy of Office on CD you can
get the Crossover Office product (www.codeweavers.com), which is a
version of "wine" that will run office products, including Access.
You can get a 30 day trial version for free. You'll need to install
the product, then use it to install Office. I know it will read .mdb
files because it does on my system under RH 9. How good the support
is I cannot say because I haven't tested it extensively. It will read
the tables, however.

A simpler way would be to get your friend to export the tables to
Excell files. Open Office, which is installed by default with Red Hat
9 *can* read excell files. You can then export these files to your
mysql databases.

You cannot open access files with mysql - they are totally different
products with totally different approaches to database management.

Ed

[Marc Schwartz]

On Wed, 05 Nov 2003 14:09:16 +0000, Ed Seedhouse wrote:

On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <[e-mail]> wrote:

I don't think it's possible, but I'll try the question.

A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql? I
googled the whole web. You are my last hope

In general no. To read Access databases you need Access, which is a
Windows product. However, if you have a copy of Office on CD you can get
the Crossover Office product (www.codeweavers.com), which is a version of
"wine" that will run office products, including Access. You can get a 30
day trial version for free. You'll need to install the product, then use
it to install Office. I know it will read .mdb files because it does on
my system under RH 9. How good the support is I cannot say because I
haven't tested it extensively. It will read the tables, however.

A simpler way would be to get your friend to export the tables to Excell
files. Open Office, which is installed by default with Red Hat 9 *can*
read excell files. You can then export these files to your mysql
databases.

You cannot open access files with mysql - they are totally different
products with totally different approaches to database management.

Ed

You might want to try MDBTools:

http://mdbtools.sourceforge.net/

You can then access the Access tables and export the data from them.

HTH,

Marc Schwartz

[Aaron Miles]

why not get your friend to export it as .csv mysql can easily import this.

Thanks

Aaron
"DD" <[e-mail]> wrote in message
news:bo**********@news2.tilbu1.nb.home.nl...

hi there,

I don't think it's possible, but I'll try the question.

A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql? I googled the whole web. You are my last hope

Thanks in advance.

Arjen

[Aaron Miles]

why not get your friend to export it as .csv mysql can easily import this.

Thanks

Aaron
"DD" <[e-mail]> wrote in message
news:bo**********@news2.tilbu1.nb.home.nl...

hi there,

I don't think it's possible, but I'll try the question.

A friend of mine mailed me a access database (.mdb), but I only use Linux
(RH 9.0) . Is there anyway that I can open the database in mysql? I googled the whole web. You are my last hope

Thanks in advance.

Arjen