Richard has pinpointed the issue The 2nd and subsequent lines in the csv file are all enclosed with speech marks Here are the 1st 3 lines when opened with Notepad
"Vehicle,Registration,VehicleGroup,ActivityDate,ActualDistance,Units" "127,HIAB 6,Auckland,1/10/2010,52.7,km" "127,HIAB 6,Auckland,4/10/2010,45.6,km" If I issue Appe from (impfile) type CSV I get the records, but they're all in first field of the table If I issue Appe from (impfile) delim I get the records, but they're all in first field of the table S On Mon, Dec 20, 2010 at 3:01 PM, Dan Covill <[email protected]> wrote: > On 12/19/2010 5:07 PM, Sytze de Boer wrote: > > It looks like a CSV file, it smeels like a csv file, but it ain't no > longer > > a csv file. > > When I open this file with Excel, and Save As, it defaults to Unicode Txt > > I assume you've looked at it in a text editor and the delimiters are ok, > the fields look the same, and the column titles are present or not > present the same as before. > > When you "open it with Excel", do you get what you expected to see? > If so, and VFP won't load it, then the character coding might have > changed. Might be worth calling Navman and asking them what they > "improved"! > > Dan Covill > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
