Closed GoogleCodeExporter closed 8 years ago
This is an issue with the Jet OLEDB provider. It looks at the first 8 rows of
the
spreadsheet to determine the data type in each column. If the column does not
contain
a field value over 256 characters in the first 8 rows, then it assumes the data
type
is text, which has a character limit of 256. The following KB article has more
information on this issue: http://support.microsoft.com/kb/281517
A solution would be to make sure one of the first 8 rows in the column has more
than
256 characters, wherein the Jet OLEDB provider will assume the data type is
memo and
will return more than 256 characters.
Original comment by paulyo...@gmail.com
on 2 Sep 2011 at 4:51
http://support.microsoft.com/kb/281517 is now a dead link.
I found useful information at http://support2.microsoft.com/kb/189897/. This
will tell you how to modify the configuration of the yet engine to sample more
rows. It involves setting a new value for TypeGuessRows in the registry.
In contrast to what the article describes, I found this key at:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access
Connectivity Engine\Engines\Excel]. I do not have Office installed, but the
Microsoft Access Database Engine Redistributable. Anyway, you can always search
the registry for 'TypeGuessRows'. I set it to 0, just to be sure to sample all
rows and it solved the issue.
Original comment by roel.sch...@gmail.com
on 20 Nov 2014 at 12:00
Original issue reported on code.google.com by
chenyong...@gmail.com
on 2 Sep 2011 at 4:09