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