>>>We want to export some tables to text files for bulk loading into SQL Server (no, we do not want to use the Upsize Wizard!). A few of these tables have memo fields which do not get copied in a COPY TO. How can we export all the fields? Any third-party code out there?
>>>
>>>TIA
>>
>>Gary, just because I'm the over-curious sort... :D)
>>Why do you not want to use Upsize Wizard?
>It has been my experience that COPY TO includes the memo fields when it copies. What has been your experience?
I haven't used COPY TO in a VFP App yet, but in 2.6 COPY TO always did copy memo fields along with other fields in the table. One thing though, I never really liked COPY MEMO...TO FILE because if your at EOF, it makes a blank file without an error message.
Also, I have used COPY MEMO...TO FILE ADDI in a loop to take small memo fields and turn them into a text file that was used to APPEND FROM...TYPE DELI into a new table without memo fields (IMHO memo fields are a real pain)
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos