I need to convert a Visual FoxPro 5.0 table with a memo field into a delimited text file. In FoxPro, I can only capture the first 254 characters of the memo field, but some of the memos are several thousand characters long. If I export the original table to a MS SQL table, can I then export the SQL table to a delimited text file and have all of the characters in the memo field included? The original table has over 7 million records. What method should I use to get the FoxPro table into SQL? Will the import via DTS work?
Thanks for any help you can give me. [sig]<p>Gladys Clemmer<br><a href=mailto:gladys.clemmer@fifsg.com>gladys.clemmer@fifsg.com</a><br><a href= > </a><br> [/sig]
Thanks for any help you can give me. [sig]<p>Gladys Clemmer<br><a href=mailto:gladys.clemmer@fifsg.com>gladys.clemmer@fifsg.com</a><br><a href= > </a><br> [/sig]