29 Feb
2016
29 Feb
'16
11:30 a.m.
On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer sytze.kiss@gmail.com 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.)