Menu
▾
▴
RE: [mdb-dev] inporting data to mysql
|
From: Gary S. <ga...@pr...> - 2003-09-07 00:58:24
|
That's the ticket... We have used it to convert a bunch of departmental = data into MySQL for a small business. It took a little bit of playing = time. BTW, ensure that each MySQL table has a date/time fields called = timestamp. Just add it if it doesn't exist. It will be useful because = some versions of access are too stupid to determine if a record has = changed or not (unless your name is SQL Server :) -- great marketing = there). Anyways, after you do the import you can easily drop the field. Gary Smith -----Original Message----- From: txemi [mailto:tx...@eu...]=20 Sent: Saturday, September 06, 2003 5:47 PM To: Gary Smith Cc: mdb...@li... Subject: RE: [mdb-dev] inporting data to mysql I found this mysql-odbc windows driver: http://www.mysql.com/downloads/api-myodbc-3.51.html I'm about to try it... 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 just 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 |