MySQL Forums :: DBF, dBASE, FoxPro, Clipper, xBASE :: mysql to csv to dbf
mysql to csv to dbf
Posted by: S D ()
Date: June 20, 2008 03:56AM
I need to transfer data from mysql to dbf(Winbooks application ) using csv. Before I insert data into the main dbf database , I have a program that checks whether dbf file I generated is correct.
mysql -> csv -> dbf(using Append from csv type delim) -> program checking dbf -> load to main dbase program
Whenever, I try this process ,the checking program reports an error. Also, when I open the dbf file(generated from mysql) with notepad , I can see the file looks very different from the other dbf files that work fine. The collation I use in mysql is utf8_general_ci. Is there something I could do to resolve this issue.
mysql -> csv -> dbf(using Append from csv type delim) -> program checking dbf -> load to main dbase program
Whenever, I try this process ,the checking program reports an error. Also, when I open the dbf file(generated from mysql) with notepad , I can see the file looks very different from the other dbf files that work fine. The collation I use in mysql is utf8_general_ci. Is there something I could do to resolve this issue.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| mysql to csv to dbf | 7803 | S D | 06/20/2008 03:56AM |
| Re: mysql to csv to dbf | 4137 | Peter Brawley | 06/20/2008 11:27AM |
| Re: mysql to csv to dbf | 4643 | S D | 06/21/2008 12:04AM |
| Re: mysql to csv to dbf | 3996 | Peter Brawley | 06/21/2008 08:42AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates