MySQL Forums :: DBF, dBASE, FoxPro, Clipper, xBASE :: mysql to csv to dbf

Advanced Search

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.

Options: ReplyQuote

Subject Views Written By Posted
mysql to csv to dbf 9446 S D 06/20/2008 03:56AM
Re: mysql to csv to dbf 4706 Peter Brawley 06/20/2008 11:27AM
Re: mysql to csv to dbf 5500 S D 06/21/2008 12:04AM
Re: mysql to csv to dbf 4640 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.