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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Judith Barer Sent: Wednesday, January 31, 2007 11:00 AM To: [email protected] Subject: RE: csv files and memo fields -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Wednesday, January 31, 2007 11:55 AM To: [EMAIL PROTECTED] 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
