From: Jesús Gómez
Date: May 30 2001 2:41pm
Subject: Re: Microsoft Access <-> MySQL Data Conversions
List-Archive: http://lists.mysql.com/mysql/75062
Message-Id: <004b01c0e916$be0ab920$6614a8c0@jesus>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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" <martin715@stripped>
To: "David Ayliffe" <me@stripped>; "Mysql Lserv" <mysql@stripped>
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 (mail@stripped)
> >
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread75055@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-jgomez=autocity.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>