May 28, 2003 at 2:59 am
Hi All,
I am trying Import data from Excel and i get this error
Data for source column is too large for the
specified buffer size.
after some search i have found out that the column exceeds the limit of 255 charater, the work around is to put a string in the first row of the column larger that 255 chars. as ita problem mentioed on MS site with Jet OLEDB Driver as it tries ot guess the datatype of the column from the first 8 rows. I want to know that is there any fix available to this problem like Service Pack etc.
Regards,
Affan
May 28, 2003 at 3:53 am
No there is no fix as it is sampling the data for best fit and if the sheet was very large would take a long time to accomplish the task. The only thing you can do is when you create the import is tweak the values in the transform section of the area where you select source and destionation tables/views. There you can tweak datatype and sizes (where applicable).
May 28, 2003 at 5:05 am
So whats the right solution for importing from excel the data having large text in columns.
May 28, 2003 at 5:21 am
Importation from Excel yields also another kind of problem. Since the data sampling is beeing done with the first 8 rows of data sometimes unwanted results can arise. For example if there is only one column in the excel sheet containing AlphaNumerics in the first rows and some rows with a number in it, the resulting import will contain NULL for the rows with a numeric.
As far as I know there is no way of getting those values into you import. There is no way of interpreting these numerics as AlphaNumerics and store them as text.
I would be very happy if anyone has a solution to this that does not involve using Excel Automation.
/Hans
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply