Jan 30, 2003 #1 Millard Programmer Feb 22, 2001 17 US I need a VFP Memo field into SQL Server. How to with SQL DTS?
Jan 30, 2003 #2 DSummZZZ Programmer Oct 24, 2000 4,250 US See if this thread helps any: thread184-459778 Dave S. Upvote 0 Downvote
Jan 31, 2003 #3 Mike Lewis Programmer Jan 10, 2003 17,516 Scotland Hi Millard, Should be no problem with DTS. Just map the memo to a SQL Server VarChar(8000). If the memo is likely to have more than 8,000 characters, try a text field instead. Would you try that and let me know if you have any problems. Mike Lewis Edinburgh, Scotland http://www.ml-consult.demon.co.uk Upvote 0 Downvote
Hi Millard, Should be no problem with DTS. Just map the memo to a SQL Server VarChar(8000). If the memo is likely to have more than 8,000 characters, try a text field instead. Would you try that and let me know if you have any problems. Mike Lewis Edinburgh, Scotland http://www.ml-consult.demon.co.uk