>Naomi,
>
>Have you checked out Craig Boyd's export to excel program? Maybe it will help you figure out what's wrong with yours.
>
>
http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,6b9d4c6f-76bb-4444-8d5b-9e321c605534.aspx>
>
>I'd be glad to test your code on my side if you want.
>
>
>
>Brandon Harker
Brandon,
I'll check his program, thanks a lot for the pointer. In the meantime, I attached the zip file with 2 programs in this message
Re: Can somebody please give a hand? Thread #
1386076 Message #
1386156 (don't reply on that one, please).
One program called Extract_Notes has a call to DBFToExcelWithMemo which is in Common_Utility (at the top). All the classes I used in my code are also in the Common_Utility. Try to set a procedure to it and slightly change the select statement to grab your data (with memo field). Try to test on big resultsets (1000+ records).
In the meantime I'm going to download VFPOleDB from the link Dmitry is sending me.
Thanks a lot again for willing to test.
If it's not broken, fix it until it is.
My Blog