Judith,
Another option might be to use a cursorToXml.
Then you can convert that to a comma separated file. If done right, you could probably automate the whole things (look up the tag in the structure to determine what type of delimiter to use.) You could even make it so you could choose a separator other than a comma (say a tab).
Of course, depending on why you want it in a CSV format, it may be that an XML format will work just as well.
Take care,
Fletcher
Fletcher Johnson FletcherSJohnson .at. Yahoo DO.T com 408-929-5678 - Cell 408-946-0960 - Work 501-421-9629 - Fax
-----Original Message----- From: profox-bounces@leafe.com [mailto:profox-bounces .at. leafe DO.T com] On Behalf Of Judith Barer Sent: Wednesday, January 31, 2007 8:21 AM To: profox@leafe.com Subject: csv files and memo fields
Does anybody have an idea how I could generate a csv file programtically that would include in it the info from memo fields. What would be the simplest way to do this?
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.
Thanks
Judith
Judith Barer
Star-K Kosher Certification
122 Slade Ave
Baltimore, MD 21208
410 484 4110
Fax 410 653 9293
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
©2007 Fletcher Johnson |