LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-23-2005, 12:57 PM   #1
thomasfingram
Member
 
Registered: Jun 2005
Location: Cary, NC
Distribution: Fedora Core 4
Posts: 44

Rep: Reputation: 15
MS Access to MySQL converter


Ok I have been a Windows user for as long as I've been using computer. I have never had success getting any kind of usable SQL database running. I do have several Access databases, some of which I relie on. One of the last tethers are these databases. Is there a tool with which I can reliably conver them with? Thank you! Btw when I do convert ( can't wait!) I will be running Slackware 10.1, if that matters.
 
Old 06-23-2005, 08:20 PM   #2
Harlin
Member
 
Registered: Dec 2004
Location: Atlanta, GA U.S.
Distribution: I play with them all :-)
Posts: 316

Rep: Reputation: 30
Are you trying to convert your .mdb (Access database files) to a MySQL database?

If so, you can export your mdb file to a comma delimited file (generally .csv or .txt). After that, you can import the .csv file with MySQL.

Take a look at this page that will tell you how to do it: http://www.modwest.com/help/kb.phtml?qid=253&cat=6.

Hope this is helpful.
 
Old 06-24-2005, 03:27 AM   #3
thomasfingram
Member
 
Registered: Jun 2005
Location: Cary, NC
Distribution: Fedora Core 4
Posts: 44

Original Poster
Rep: Reputation: 15
Well I was kinda hoping for a more direct approach, in which I wouldn't have to recreate the tables and relationships again...
 
Old 06-24-2005, 03:38 AM   #4
Harlin
Member
 
Registered: Dec 2004
Location: Atlanta, GA U.S.
Distribution: I play with them all :-)
Posts: 316

Rep: Reputation: 30
You'll need to first recreate the columns that are used in the Access database file and then apply the same to your MySQL db. Next, you'll import .csv files that were created from the Access file. It doesn't get any simpler than that.

I am not certain that you can actually import the Access database unless you use an odbc driver (not sure if one actually exists in this manner >>). I know you can access a MySQL database with Access client, but accessing an Access db with a MySQL client, I don't think that's been done. If anyone knows of a way to do this, please post it.
 
Old 06-24-2005, 04:00 AM   #5
somarasa
LQ Newbie
 
Registered: Jun 2005
Location: Bulgaria, Sofia
Distribution: Mandrake 10.2 - Mandriva LE 2005
Posts: 15

Rep: Reputation: 0
Export to .csv
then use phpmyadmin to import .csv files to sql db

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields

You must have Apache - running to use phpmydmin

http://sourceforge.net/projects/phpmyadmin/
 
Old 06-24-2005, 04:33 PM   #6
Harlin
Member
 
Registered: Dec 2004
Location: Atlanta, GA U.S.
Distribution: I play with them all :-)
Posts: 316

Rep: Reputation: 30
There's really no need to install an extra app to get this done. All modern SQL packages include functionality to import common text file fomats this includes MySQL. If you will take a look at the page I listed above, you'll see exactly how to do it.

However, <sigh> if you must use phpMySQLAdmin, it is very simple to import .csv files... that I will acquiese .
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
access to mysql converter Skaan Linux - Newbie 2 06-02-2005 07:43 AM
How access MySQL by MySQL Administrator? treotan Linux - Newbie 5 12-04-2004 11:17 PM
from access to mysql ? abd_bela Programming 1 02-12-2004 08:57 AM
MySQl access from C++ rob99 Programming 6 06-23-2003 02:25 PM
mysql and access mychl Programming 2 06-11-2003 07:00 PM


All times are GMT -5. The time now is 02:47 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration