In trying to import a paradox memo field to an SQL server table, I am getting the error "Data source for column is too large for the specified buffer size".
I have imported this field many times before with no problem at all. Just wondering if anyone can tell me if there is a problem with the Paradox source table or SQL Server, and what to look for.
Had the same error when trying to import data from excel, had to change a registry setting to fix - down to JET, may be the same for paradox. See the following microsoft knowledge base article for details
That is it for sure. I could import the field into Excel and into Access but not into SQL Server. Turns out the first 8 rows were null so JET didn't see the field as a text field.