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 > easiest way to convert Access DB into SQL?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-14-09, 12:23
Alistair Alistair is offline
Registered User
 
Join Date: Dec 2009
Posts: 12
easiest way to convert Access DB into SQL?

I want to try my Access DB into Joomla but the latter is only compatible with SQL, what's the easiest + quickest + idiot-proof way to convert Access DB into SQL?
Reply With Quote
  #2 (permalink)  
Old 12-14-09, 12:28
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,250
well seeing as Access is a variant of SQL I'm confused, unless you mean the Joomala only works with specific SQL engines

there use to be a tool called dbtools which would do the job pretty painlessly

failing that you could explore the MySQL Migration tool

failing that you could export the data using CSV files or simialr, and then load the data within MySQL
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 12-14-09, 13:51
sakis sakis is offline
Registered User
 
Join Date: Nov 2009
Posts: 19
You could also load it as SQL.
Try to find if access exports sql
Reply With Quote
  #4 (permalink)  
Old 12-14-09, 19:13
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
Quote:
Originally Posted by sakis View Post
You could also load it as SQL.
Try to find if access exports sql
maybe ~you~ should see if Access can export SQL, before you suggest it

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 12-15-09, 10:56
Alistair Alistair is offline
Registered User
 
Join Date: Dec 2009
Posts: 12
Hey, if anyone is interested I managed with a very idiot-proof (the idiot here being me) software called bullzip, pretty quick too
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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