I would use VFP to edit your csv table in orde to avoid Excel messing up your character fields into numberic Regards Koen
Op maandag 29 februari 2016 heeft Ted Roche tedroche@gmail.com het volgende geschreven:
On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer <sytze.kiss@gmail.com javascript:;> wrote:
I make some changes to the price (using Excel) I now import from this same file and the supcode has changed to 12345.56
Whats the best way to overcome this?
If you're exporting a field that looks like a number, Excel will helpfully try to convert the column into a number. If you want it to remain as a text field, precede the fields with a single quote:
select [']+code, price, [']+supcode from mytable to tempcursor copy to tesfile.csv type csv
Alternatively, there may be some option in the Excel import dialog to turn off "Smart Parsing" or whatever Excel calls it. (LibreOffice user, sorry.)
[excessive quoting removed by server]