My experience (I'm one of them there VFP programmer types) with dbfs is that it's often easier to export to a more general format (CSV, tab-delimited, DIF, etc) than to try to do anything with DBFs directly.
One method is to export the DBF to a comma-delimited file, then use: LOAD DATA ... (chapter 6.4.9 in MySQL docs) Of course, the above method depends on what sort of access you have to the MySQL server. If you can conect to the server directly, then you may want to consider using mysqlimport (chapter 4.8.7 in MySQL docs) instead. Another method would be to upload a comma-delimited version of the file, and parse each record into a series of INSERT... statements. This does not require direct access to the server, but is also much slower. Note that you can insert more than one record at a time with a single INSERT statement in MySQL (which is not the case for VFP's INSERT...). This would speed up your import process by reducing the number of requests being sent to the MySQL server. You could probably find such a script (or something close) by looking through the various PHP code archives available all over the Web... Also note that there is a dBase module for PHP, but most installations do not have it installed by default. Also, even if you did have it installed, you would still need the same level of access as the first option above. As a result, if you have this sort of access, just use the first option... --- Seairth Jacobs [EMAIL PROTECTED] "Marlene Burckhalter" <[EMAIL PROTECTED]> wrote in message 001301c24eea$5710ae60$6401a8c0@MarleneGateway">news:001301c24eea$5710ae60$6401a8c0@MarleneGateway... hi how would i go about moving data from a dbf to mysql with php? if the php documentation help covers this, what phrase do i key in to search? marlene -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
