[mdb-dev] inporting data to mysql

[txemi <tx...@eu...>]

Hi, I am trying to export data from microsoft access to mysql.

I am doing it exporting text data from Microsoft Access or mdbtools to
text files and then inporting it with LOAD DATA from mysql. The problem
is than I cannot find a combination of field deparator, escape secuence,
etc... for not loosing data in the transfer.

Could anybody provide a hint to do it in other way? Perhaps using odbc
or something like that?

-- 
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org