Re: [PHP-DB] export mysql table to .dbf

[Norma Ramirez - TECNOSOFT]

Thank´s Stephen, I gonna try it looks very useful...

Norma Ramirez



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] export mysql table to .dbf

[Stephen March]

Norma,

   I have found the best strategy is to setup an ODBC link to an 
alternative to the database.   As an example, I had a mysql database 
"intranet", and I created an ODBC link to, with the MySQL ODBC drivers 
(from the mysql.com site), and then opened up Microsoft Access.Went 
file => get external data  =>  import data, selected the tables, and 
bingo, they were in Microsoft Access, mdb format.   I would expect you 
should be able to do the same thing with Fox 2.0, and any other database 
that you have a GUI for.   I know most systems come with ODBC drivers 
for Foxpro,

HTH
~Steve
Norma Ramirez - TECNOSOFT wrote:

Hi all, does any one how export data from mysql to fox 2.0? I have to capture data from a php form and store in mysql database, and then export those data or generate a .dbf table. 
Thank´s a lot. 

Norma Ramirez

 





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] export mysql table to .dbf

[Norma Ramirez - TECNOSOFT]

Hi all, does any one how export data from mysql to fox 2.0? I have to capture data 
from a php form and store in mysql database, and then export those data or generate a 
.dbf table. 
Thank´s a lot. 

Norma Ramirez