Date: 08/16/05 (SQL Server)    Keywords: sql

Related to my last post with only the most tenuous of links. (I've been trying to see what's been going on with these stupid tables, which takes a lot longer than three minutes, but am too damned lazy to run the queries in Query Analyzer.)

Is there a simple way of importing VFP (6.0) tables containing memo fields into SQL Server (2000)? No matter how I try to do it, the import completely ingores the memo fields. E.g.:

VFP
column 1 - character(5)
column 2 - memo
column 3 - memo
column 4 - int

SQL
column 1 - character (5)
column 2 - int
column 3 - filled with NULLs
column 4 - filled with NULLs

I've tried going straight through ODBC and copying out to text then importing from SQL from the text file; same result.

This is something that's plagued me on and off throughout the years, but now I'm actually trying to do it for a project at work instead of for my own gratification, so I've got people who need this stuff...

thanks.

Source: http://www.livejournal.com/community/sqlserver/30747.html