SQLServerCentral / Data Warehousing / Data Transformation Services (DTS) / Importing paradox memo field / Latest Posts

RE: Importing paradox memo field

slimchance99 — Thu, 12 Feb 2004 09:30:00 GMT

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

RE: Importing paradox memo field

Ron Banks — Wed, 11 Feb 2004 03:42:00 GMT

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

http://support.microsoft.com/?kbid=281517

Importing paradox memo field

slimchance99 — Mon, 09 Feb 2004 07:34:00 GMT

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