Tab Alleman (6/7/2013)
Palash Mitra (3/7/2011)
On doing some web searches I have come across suggestions to increase TypeGuessRows doing registry edit.
Ref: http://support.microsoft.com/kb/281517
That KB article says it only applies to SQL 2000 and 7.0. Can anyone confirm that this registry key is still used with 2005+?
(I am a developer who doesn't have machine-level access to our SQL Server, or I'd look myself)
It works for every version of the JET OLE DB provider (right until Excel 2003) and for every version of the ACE OLE DB provider (until Excel 2013 for the moment).
The version of SQL Server doesn't matter, it is the OLE DB provider that is giving issues.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP