>If I want to store the contents of a VFE memo field (all text) into MS SQL, what data type do I use for the SQL table?

It depends on the size of the memo field. You can use varchar data type if the size is less than 8,000 bytes or text otherwise. Actually, 8,000 bytes is the limit on the varchar column itself. Considering that the record size is limited to 8,060 bytes and record has other columns, the limit on the varchar column could be even lower.