RE: [PHP] UNIX MySQL to Microsoft Access

You can also set up a 'live' link, via ODBC. Access can consume ODBC resources, so you can link tables into it from MySQL. MyODBC should provide the linking you need. Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers -----Original Message----- From: Jeff Gannaway [mailto:webmaster@cactusgraphics.com] Sent: Monday, July 24, 2000 2:29 PM To: devolve@hotbot.com; php-general@lists.php.net Subject: Re: [PHP] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net