>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.