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.pil...@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 <tedro...@gmail.com> het
> volgende geschreven:
>
> > On Mon, Feb 29, 2016 at 6:47 AM, Koen Piller <koen.pil...@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]
_______________________________________________
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/CAMvTR9eG1RSJ-2LnX=z7rgh7rhdgbfvmhg5xip-g_qfhhfy...@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.
