Don't know if this helps, but you could try changing the number format of columns 1 and 3 in the worksheet to "Text". From VFP, you'd do something like this:
*!* Assume oSheet is a reference to the Excel.ActiveSheet WITH oSheet .Columns(1).Numberformat = "@" .Columns(3).Numberformat = "@" ENDWITH
Laurie
On 29 February 2016 at 12:19, Koen Piller koen.piller@gmail.com wrote:
Suppose you are correct however in the question Sytzke said <I use> Regards Koen
Op maandag 29 februari 2016 heeft Ted Roche tedroche@gmail.com het volgende geschreven:
On Mon, Feb 29, 2016 at 6:47 AM, Koen Piller <koen.piller@gmail.com javascript:;> wrote:
I would use VFP to edit your csv table in orde to avoid Excel messing
up
your character fields into numberic
Well, sure, but Sytze is using Excel (or more likely, having a client use Excel) for some reason he hasn't shared with us. A LOT of my clients do everything in Excel and expect us to magically move it in and out of VFP, so it's a handy skill to have.
I mean, if Sytze is editing his database in CSV, we ought to point out he should edit it in VFP. Browses are even better than CSV. :)
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]