I don't have foxpro here, but use the old
Copy to file name type sdf, substituting sdf with whatever it is that
creates an excel file.
Seems like it is TYPE 123, but I'm not sure...
Virgil Bierschwale
http://www.bierschwalesolutions.com
-----Original Message-----
From: profox-bounces At leafe .DOT com [mailto:profox-bounces@leafe.com] On Behalf
Of Judith Barer
Sent: Wednesday, January 31, 2007 11:00 AM
To: profox At leafe .DOT com
Subject: RE: csv files and memo fields
-----Original Message-----
From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces At leafe .DOT com]
On Behalf Of Vince Teachout
Sent: Wednesday, January 31, 2007 11:55 AM
To: profoxtech@leafe.com
Subject: Re: csv files and memo fields
Judith Barer wrote:
> I also would like to take a csv file and append it to a dbf file with
> memo fields. I tried converting the file to a string using strtofile
> and then using a alines but the file is so big that it generates a
> subscript out of range error. I am using VFP 8.0.
>
>>I'm just curious here. If you're taking output from one dbf with the
>>goal of getting it into another, why can't you just COPY TO
MYTRANSFER,
>>and then append from MyTransfer into the other file?
I am not taking one dbf file and transferring it to another. What I am
doing is sharing data. I work for a kosher certifying agency and what I am
doing is sharing data with other certifying agencies so I am supposed to
create csv files of our data and download csv files of other agencies data.
There are definitely better ways to approach this issue such as
using web services and such but we are not doing that. We had agreed
to use XML files which worked fine but the files are quite large. So some
agencies requested to use csv instead. For me csv seems to be a hassle but
using cursortoxml and xmltocursor worked very nicely for me.
Thanks
[excessive quoting removed by server]
©2007 Virgil Bierschwale |
