This is really easy using ODBC... Download the Access MySQL ODBC drivers
from www.mysql.com
There is documentation there as well I believe, but it's pretty straight
forward.
Cheers,
John
-----Original Message-----
From: Julian de la Guia [mailto:julian.guia@stripped]
Sent: Thursday, May 06, 1999 9:08 AM
To: Forum mySQL
Subject: Convert Access to mySQL
Hello mySQL-World,
This is my first message in this email list and this is my
first experience in mySQL. O:)
I want to convert tables and queries (views) from M$ Access
to mySQL but I have some problems. I have downloaded script
converter for Access but this script only builds and fills
the tables (I have some problems with compatibility types
data too) and my question is: Can I convert the Access
queries to mySQL automatically? Yes? No? How?
mySQL doesn't import Access files and Access doesn'nt export
mySQL files. I have other idea: export from Access trought
ODBC but I don't know how to make it. Do you know where I
can read information about this method?
I'm installing Red Hat 5.2 in this moment and I'll install
mySQL last version. Meanwhile, I'm thinking in my problem, a
BIG problem because I have used Microsoft Access. Sorry O:)
Thanks in advance, :)
Best regards,
Julian
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
posting. To request this thread, e-mail mysql-thread2967@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
