Ofcourse you can use with access2000.
Create a text file by using export option in access2000.
Then use LOAD DATA in Mysql.
Ajay K. Ratra
[EMAIL PROTECTED]
"Neil Davies"
<neil.davies@ll To: [EMAIL PROTECTED]
gc.org.uk> cc:
Subject: load access-mysql
09/03/01 02:51
PM
I have a very large database which was made using Access2000.
Because of the difficulty Access has in manipulating the database
due to its scale I want to move the database to MySQL. However,
because of the size of the database I don't want to spend hours
doing it by hand so I want to use LOAD DATA or something similar
but what I want to know is - can you use this function, or a similar
one, to load a database from access2000 to MySQL, and is there
anything I need to be aware of if this is possible?
Thanks,
Neil
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
