I need to export my Sales Data to CSV file for Accounting software to import.
My problem is the software require a empty line between each record.
I try to insert a empty record between each record to my vfp table and then do the export. Then I got
cusid,invNo,amt,date
c001,123,200.00,01/01/2000
,,,,
c002,131,20.00,02/01/2000
,,,,
But the Accounting software still cannot accept because of ,,,,. So How can I make it like below :
cusid,invNo,amt,date
c001,123,200.00,01/01/2000
c002,131,20.00,02/01/2000
Thank in advance.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement