MySQL Forums
Forum List  »  Other Migration

Re: mysql to csv to dbf
Posted by: S D
Date: June 21, 2008 12:04AM

The checker takes a dbf file.
I generate this temporary dbf file through Append from ... csv command. The checker program checks the temp dbf file and then uploads it to the main dbf program.

Well, now I discover why the files fail to upload.

The blank numeric fields in the csv file get converted to 0.000 value in this dbase file (the bdase type is NUMERIC 17 3).
Is there a way to avoid the files getting this stamp
OR
Is there an option to get dbf directly from mysql or perhaps a php script that does this. The server running mysql is a Debian Sarge server and cannot be connected to the dbase server(on Windows).

Options: ReplyQuote


Subject
Views
Written By
Posted
10506
S D
June 20, 2008 03:56AM
5092
June 20, 2008 11:27AM
Re: mysql to csv to dbf
6117
S D
June 21, 2008 12:04AM
5031
June 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.