July 23, 2002 at 12:00 am
I am trying to load the excel file to a table using DTS. I am getting the following error.
General Error - 2147217187
Too large for specified buffer size
How to increase the buffer size for DTS.
Advance Thanks for your help.
email address
July 25, 2002 at 6:15 pm
In your DTS import you can specify the target table which unless you built will build for you. Using the Import/Export Wizard, when you get to "Select Source Tables and Views" screen in the grid slid over to transform for the items selected and check the output size for the column. You should be able to adjust there.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply