Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have a CSV file that I am able to download from a company that provides us with electronic invoices. When I open this file in Microsoft Excel, the data is correctly parsed into the columns. If I try to import the same file into VFP using this statement:
append from c:\dwnld\tabledata.csv type csv
into a table that is open, that I have set up with nine columns of character type fields, the data does not parse out correctly. It seems like if a character type item in an original record is empty, VFP 'skips' this column and goes right to the next one. When I look at the line in the original csv file, it looks like this:
WDL ,96788853 ,02/24/2009 ,55748761 ,22442061 ,"CURRENT_CHARGES" , ,"5645867" ,"SMITH ,JANE M" ,"00083723" ,01/15/2009 ,"PATH REVIEW, LIQ PAP" ,88141 ,"RLB1" ,"" ,"$25.00"
Am I, perhaps, doing something wrong in my VFP syntax?
C
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