What I'd like to know is how can I (what tools/scripts to use to) export
an Access table to a MySQL database.
Any help appreciated.
Thanks in advance
Naresh Bhagtani
IndiaLive Net Solutions
http://www.indialive.net
webmaster@stripped wrote:
>
> On 9 Apr 99, at 17:43, Jeffrey Mercer wrote:
>
> > I have fairly big table to be exported ( via access97 ) to a mysql DB
> > running on a remote server.
> >
> >
> > Each attempt results in err: (TCX)(MyODBC)Unknown column '110yyyyy' in
> > 'field list'(#1054)
>
> How big is big? I do the same from Access into msql. I have a perl
> script which runs on my NT box to extract the data I need from the
> various tables in Access and then it creates new tables with the data
> to import into msql (I use the same format as a dump produces).
> Works like a charm. Only problem is that it takes about 20 minutes to
> do the import -- and all the time it is echoing back each insert.
> mysql doesn't do this (and I don't know how to turn it off in msql)..
> But I digress.
>
> How do you export from access and then import into mysql? Do you
> check the data first? I make sure that each field contains just what
> it should (in the perl script of course).
>
> Peter
>
> Might is not Right. But there is a lot of Might knocking
> about in this world, and something has to be done about it.
> -- King Arthur, The Once and Future King
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread1634@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
