>I am trying to import a wide data set. It has several columns that are 2500+ text. The columns they are going to are text columns. I get an error:
>
>Data for source column 12 ('item') is too large for the specified buffer size.
>
>Do I need to split the file down the middle and do two halves? Is there a better way?
See if
PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error mskb #
281517 helps.
--sb--