Can I convert MySQL table to DBF table?

[warik]

Dear all,

I have a database server running with MySQL database which using for webpage database.

I just thinking of convert that MySQL tables to DBF file, so I could manipulate the tables with my personal PC and maybe I could make a simple form for that tables using VFP.

Thank you in advance.

 

[Mike Lewis]

Warik,

As far as I know, the easiest way would be to set up a remote view within Visual Foxpro. You will need an ODBC driver for MySQL. The remote view will let you access a MySQL table just as if it was a DBF. Once you have done that, you can copy the table to a real DBF.

Check the Help on remote views, and come back if you get stuck.

There might be a simpler way of doing it -- I don't know MySQL very well -- perhaps someone else will point you to it. Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk