If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > If I have an Access DataBase how to convert to MySQL

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-01-10, 04:47
lse123 lse123 is offline
Registered User
 
Join Date: May 2007
Posts: 130
If I have an Access DataBase how to convert to MySQL

If I have an Access DataBase how to convert to MySQL?
I have to export sql file and to import mysql?
Reply With Quote
  #2 (permalink)  
Old 09-01-10, 04:54
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 8,768
there used to be a tool called dbtools whi9ch was free and did the job
...looks like there still is

I don't think the mySQL migration toolkit (part of the MySQL GUI tools) available fromt he MySQL website does it but you may want to check

failing that its an export from MySQL to a CSV file and import into MySQL.
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 09-01-10, 05:53
lse123 lse123 is offline
Registered User
 
Join Date: May 2007
Posts: 130
by "MySQL to a CSV" you mean Access, ?

I want the structure of db (or and data in) trasfered: Access->mysql?
Reply With Quote
  #4 (permalink)  
Old 09-01-10, 15:57
hari321 hari321 is offline
Registered User
 
Join Date: Sep 2010
Posts: 1
I used dbtools in the distant past and it worked well on a simple Access Database. DBTools Software - Welcome to DBTools Software

It was reasonably priced and simple to use
Reply With Quote
  #5 (permalink)  
Old 09-01-10, 18:51
lse123 lse123 is offline
Registered User
 
Join Date: May 2007
Posts: 130
MAY VIA ACCESS get make an .sql file of the schema, and after import it to MySQL

MAY VIA ACCESS get make an .sql file of the schema, and after import it to MySQL?
Reply With Quote
  #6 (permalink)  
Old 09-01-10, 23:18
guelphdad guelphdad is offline
Registered User
 
Join Date: Mar 2004
Posts: 435
you may find that you need to make some changes to the data types but otherwise that could work. try it and see.
Reply With Quote
  #7 (permalink)  
Old 09-02-10, 04:50
msjs msjs is offline
Registered User
 
Join Date: Sep 2010
Posts: 3
I've been looking for an alternative to M$Access for the last few weeks solid.

Kexi from Koffice is supposed to be able to open data tables and convert them to another format from an MDB file. Haven't tried this yet. OOO Base can't. Datakiosk is unmaintained. SQLyog can't. MySQL Administrator can't. phpMyAdmin can't.
Kexi can't yet do composite primary keys though but you might be able to convert using Kexi and then access the resulting MySQL db with something else.

I'm next going to look at using MySQL Administrator to create my db and xataface to create the queries, forms, reports etc in php but it looks like I have to learn SQL to code some stuff.
HTH
Max
Reply With Quote
  #8 (permalink)  
Old 09-02-10, 05:15
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 8,768
try the MySQL migration toolkit
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #9 (permalink)  
Old 09-03-10, 21:43
mnirwan mnirwan is offline
Registered User
 
Join Date: Sep 2009
Posts: 64
If I were you, I'd install MySQL ODBC connector. Then from Access, create new database pointing to your MySQL (using ODBC). Then from within access, import from another access file.
Reply With Quote
Reply

Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On