SQL Buffer Size problem

I am attempting to import records from ACCESS to SQL. I've done this hundreds of times and never run into this problem before. The ACCESS database contains 451 records one of it's fields is called SEARCH. This is a memo field in access and can be pretty large (between 900 and 1200 characters). I get the following error message when I attempt to import the records:

"Error at Source for Row number 434. Errors encountered so far in this task: 1. Data for siurce column 9 ("SEARCH") is too large for the specified buffer size."

Does anyone know how I can correct this problem?

Thanks,

Cinnamon

Look into the Connection Objects OLEDB Properties. The Buffer Size can be tweaked as needed. However, this must go AFTER the cn.Open method, like so:



cn.ConnectionString = strFile
cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.Open
cn.Properties("Jet OLEDB:Max Buffer Size") = 256



And it is advisable to store the current buffer size in a variable and return this property to its initial state when your work is finished.