Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo field to Text File

Status
Not open for further replies.

dzdncnfsd

MIS
Jul 14, 2000
118
US
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top