http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027&showtopic=1536&view=getnewpost
Karam
--- Bing Du <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've been looking around for a while. Seems there
> are many options and
> tools that can help do it. Guidance and directions
> ar
> Hello,
>
> I've been looking around for a while. Seems there are many options and
> tools that can help do it. Guidance and directions are highly welcome.
>
> We need to move the contents of a bunch of tables from Access to the
> existing tables on MySQL. The target tables in MySQL already hav
cript that copies the records directly
from Access to mySQL via ODBC. It uses DoCmd.TransferDatabase, if you'd
like to write your own.
I'd be happy to share it.
-- Brett
- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 28, 200
Make a select query in Access whose result mimics the table layout of
the target table in MySQL. Then export the query as tab-delimited text
and import into the MySQL table using LOAD DATA INFILE.
On Jul 28, 2005, at 12:32 PM, Bing Du wrote:
Hello,
I've been looking around for a while. Seem
Hello,
I've been looking around for a while. Seems there are many options and
tools that can help do it. Guidance and directions are highly welcome.
We need to move the contents of a bunch of tables from Access to the
existing tables on MySQL. The target tables in MySQL already have some
infor
