You can use MyODBC to get data from Acces and insert it into mysql with
VisualBasic,C++,etc.
Also you can import mysql tables into acces with myodbc.
----- Original Message -----
From: "Jacob Martin" <[EMAIL PROTECTED]>
To: "David Ayliffe" <[EMAIL PROTECTED]>; "Mysql Lserv" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 3:58 PM
Subject: Re: Microsoft Access <-> MySQL Data Conversions
> 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
>
>
---------------------------------------------------------------------
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
