I found that it's much easier to write a program that connects to both
databases and copies by inserting. That way you don't have to fool with
files at all.
However, I don't know if there are drawbacks to this or not. Anyone know
if there any character set conversion issues or otherwise?
David Ayliffe wrote:
> 1) Whats the easiest way to convert data from Microsoft Access TO MySQL?
>
> (i'm thinking export a table using VB (with recordsets,) format into
> MySQL format and then mysql < msaccess.dump into MySQL via a C++
> proggie)
2) And the easiest way to convert data from MySQL TO MS Access?
>
> (Using C++ API to get data from a mysql table..... then I get stuck.
> How could I automatically import it into MS Access DB of users choice,
> formatting etc??)
>
>
> ANY ideas appreciated
>
> Thanks lots
> David Ayliffe ([EMAIL PROTECTED])
>
---------------------------------------------------------------------
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