dbf to csv to dbf
dbf to csv to dbf
(OP)
I need to upload csv data into an accounting package.
csv -> dbf(using Append from csv type delim) -> program checking dbf -> load to main dbase program
To test the setup, I have downloaded a file that imports perfectly, converted into csv , and used Append command to create dbf. The file size gets increased by a few bytes (34 bytes) for a 600KB files and the checking program reports error. I guess I am missing out something. Any ideas???
csv -> dbf(using Append from csv type delim) -> program checking dbf -> load to main dbase program
To test the setup, I have downloaded a file that imports perfectly, converted into csv , and used Append command to create dbf. The file size gets increased by a few bytes (34 bytes) for a 600KB files and the checking program reports error. I guess I am missing out something. Any ideas???
RE: dbf to csv to dbf
If you can control it, get a the download as a DBF or SDF instead of a CSV.
If not add a extra column to a CSV import and checks the extera field for data. If any data exist in the extra field, then you have a user added comma in the data.
David W. Grewe Dave
RE: dbf to csv to dbf
I cannot get output as sdf or dbf.
Now , I have progressed a little - the reason why the file shows a few bytes more is that the numeric fields that are blank gets a stamp of 0.000 . The dbase field has the type NUMERIC 17,3. The dbf files that upload donot get this stamp.How can I prevent the files from getting this default value (0.000) when I use append to import the csv file.
RE: dbf to csv to dbf
David W. Grewe Dave