Hi,
you have to create an exportfile with ACCESS separated with colons for
example.
Then import this textfile in your mysql-database.
It looks like this:
LOAD DATA LOCAL INFILE "C:\\name_of_your_file.txt"
INTO TABLE name_of_your_table
FIELDS TERMINATED BY 'your_separator for example ,'
ENCLOSED BY '"'
(name of the table fields);
Hope that helps!
Patrick
-----Ursprüngliche Nachricht-----
Von: Javier Garcia [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 14. März 2001 14:54
An: [EMAIL PROTECTED]
Betreff: Importing ACCESS into MYSQL
Hi
Does anybody know how to import MDB's into MYSql.
Thanks
Javier
---------------------------------------------------------------------
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
