Re: UNIX MySQL to Microsoft Access

At 03:01 PM 7/24/00 -0700, bob Dobolina wrote: >I need to in someway convert a MySQL database on a FreeBSD Unix machine over to a Microsoft Access database. I'll also need to update the Access database with information from the MySQL version occasionaly. I've read a few archived messages that touched on this, but were unable to fully explain what would be involved. I understand that I'll probably need to convert the MySQL database over to ODBC first then somehow get that imported into Access. Any help or guidance would be greatly appreciated. Thanks in advance. Go to http://www.mysql.com and search the docs for: LOAD DATA INFILE and SELECT INTO You use SELECT... INTO... to creatre a flat text file of a table that can be imported into MSAccess and you can use LOAD DATA INTILE... to import info from a text file (in this case a text file create by using MSAccess' EXPORT option) into a MySQL table. I use this technique a lot. It's pretty easy to write an import/export script to do most of it without having to telnet. Feel free to e-mail me with more specific questions. -Jeff Gannaway