From: txemi <tx...@eu...> - 2003-09-07 00:44:11
|
Yeah, it does not use mdbtools, but I like it. I have not experience with odbc, so I will ask you for a litle more help... Is this what you tell me to do? - I put the mdb file on a windows machine. - I put the odbc driver on the linux/mysql machine. (should be obcd-mysql driver be there or in the windows machine instead? Is odbc an api or does it have a network protocol? should I find a mysql-odbc windows driver?) - I configure a odbc source in odbc.ini in linux machine. - From windows y try to configure a odbc data source pointing to odbc source on linux machine. - From ms access I try to reach the newly odbc configured mysql database. - Now should be able to easely copy data from one database to other using access. Is this right or am I completely wrong? :-) Thanks for your quick answer, txemi. El dom, 07-09-2003 a las 01:13, Gary Smith escribi=F3: > If you have access to the Win platform install the MySQL ODBC drive and j= ust create a query. I know this has nothing to do with MDB-DEV app but it'= s simple and fast. >=20 > Gary Smith >=20 > =20 >=20 > -----Original Message----- > From: txemi [mailto:tx...@eu...]=20 > Sent: Saturday, September 06, 2003 3:24 PM > To: mdb...@li... > Subject: [mdb-dev] inporting data to mysql >=20 >=20 > Hi, I am trying to export data from microsoft access to mysql. >=20 > 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. >=20 > Could anybody provide a hint to do it in other way? Perhaps using odbc > or something like that? --=20 ______________________________ < hola, soy una firma horrible > ------------------------------ \ ^__^ \ (oo)\_______ (__)\ )\/\ ||----w | || || txemi <tx...@eu...> web: http://txemi.webhop.org mirror: http://txemi2.webhop.org |