Tech Support banner

Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
14 Posts
Discussion Starter #1
deaR TECHIES,

CAN ANY ONE TEL ME HOW TO CONVERT A MS ACCESS DATABASE INTO MYSQL FORMAT.

THANKS
KARTHIK
 

·
Registered
Joined
·
1,393 Posts
Write a query to get the data you want. Export the data in a comma delimited file. Import the file into SQL.

Or you can export the tables directly into a comma delmited file and do the same thing.
 

·
Registered
Joined
·
14 Posts
Discussion Starter #3
kind attn pseudo

dear pseudo,

thanx for your support..

i just have a fair idea about working in an database software..

if you could explain me in an lay-mans language..i would be able to grasp your point.

thans again
kartz
 

·
Registered
Joined
·
1,393 Posts
That WAS the lay man's version. ;)

LOL. What version of Access are you using?

A query is a tool to pull data from different tables that meet different criteria.

How much do you know about Access? Do you know what tables and query's are? Do you know how to write querys?

I believe there is an ODBC driver that will let you connect Access to MySQL directly. You'll have to research this though - I haven't used it. I also haven't used MySQL.

An ODBC driver is an Open Data Base Connectivity Driver that will let you connect different types of databases together. This would be the most elegant way to do it.

The quick and dirty way would be to export your data into comma delimited files and then import into MySQL.
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top