I need to take the contents of a FoxPro database (don't know what version or FP vs. VFP) and add them to a MySQL database. Every night at 3am, I need to download the .dbf files from an FTP site and get the data out of them.
How the heck do I do this? I've tried looking at iODBC but I don't know if this will work since the dbf files and the script are on a Linux box. Plus I can't find any ODBC drivers for VFP.
HELP! Thanks!
-derek
man, i have no clue...i thought i was the last person on earth still using that ancient good for nothing program (FOX PRO)...what a piece of programming crap...from my experience you\'d have a better chance of going from FOx Pro to Access...they\'re much more compatible...but, who knows man...i was no help whatsoever...hehe!
PHP has dBase file handling utilities that allow you to do basic things to dBase files (open, look at records, delete them ). Using that you could step thru the dbf record by record and then insert each record into the SQL database. If you would like some code examples please e-mail me privately (ac209@acorn.net).
John Mertic