February 9, 2004 at 7:34 am
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.
Thanks
Tim
February 11, 2004 at 3:42 am
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
February 12, 2004 at 9:30 am
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.
Thanks
Tim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply