On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer <sytze.k...@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.) _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4vyut7wk1s2awxudzcxo2kmcj2x7d1p8rnchdx_aaw...@mail.gmail.com ** 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.
