access has a module called exportaccesstomysql which will convert the access
DB to 2 text files. One contains a series of SQL statements to create the
various tables in MySQL and also add entries which are in the access DB. If
you have a win-32 version of nysql you can use this to create the DB on the
MySQL server. You may find some problems as the module doesn't set some
values in tables to NOT NULL and MySQL will expect them to be defined as NOT
NULL.
Enda
-----Original Message-----
From: Gabriel [mailto:[EMAIL PROTECTED]]
Sent: 21 August 2001 13:43
To: [EMAIL PROTECTED]
Subject: Import from Access to MySql
Anyone can tell me how can i import an access db to mysql.
Thanks in advance,
Gabriel.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
