473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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
Jul 19 '05 #1
6 3470
On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <ad@ad.nl> 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

Jul 19 '05 #2
On Wed, 05 Nov 2003 14:09:16 +0000, Ed Seedhouse wrote:
On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <ad@ad.nl> 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

Jul 19 '05 #3
On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <ad@ad.nl> 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

Jul 19 '05 #4
On Wed, 05 Nov 2003 14:09:16 +0000, Ed Seedhouse wrote:
On Tue, 4 Nov 2003 21:22:47 +0100, "DD" <ad@ad.nl> 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

Jul 19 '05 #5
why not get your friend to export it as .csv mysql can easily import this.

Thanks

Aaron
"DD" <ad@ad.nl> 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

Jul 19 '05 #6
why not get your friend to export it as .csv mysql can easily import this.

Thanks

Aaron
"DD" <ad@ad.nl> 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

Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Ruby Tuesday | last post by:
How do I transfer my MS Access DB to MySQL? One issue though, in Access I have some special character such fraction, backquote, etc ... how do I replace those characters to ASCI equivalent...
2
by: Steve Briley | last post by:
I'm new to Python and I'm trying to do some database work with MS Access, but I can't seem to get around a "datatype mismatch error".&nbsp; Here's an example table that I'm working with... ...
2
by: Carsten L. | last post by:
A couple of years ago a guy posted his tool in this newsgroup which was able to import access databases into oracle, mysql,etc. Does anybody still know how the tools name was? Thanks Carsten
0
by: mikey | last post by:
Hi all, I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I...
2
by: The Plankmeister | last post by:
Hi, I am converting some queries from stored procedures in MS Access to MySQL, and have hit my first problem. The Access query references another stored procedure, which is where the problem...
10
by: david | last post by:
Hi, I have the following code which returns an error when run as part of my ASP SQL.... strquery = strquery & "FROM (Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID)...
3
by: Zman | last post by:
I've recently added form functionality on my website, which runs with the aid of a perl script and sends the results via an email message. I'm currently able to import, or link, data from a...
3
by: hSiplu | last post by:
hi all, I am creating a web project with php/mysql. one of qeury result is too high. it returs several thousand rows. But I can't show them in one page. So I wanna create more than one pages...
4
by: Richard | last post by:
hi there, i've got a mysql database with a research data. i would like to get some information from that database and save it as ms access database. it will be a client feature. the client...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.