Help with a OleDB connection string for excel files

Once you set TypeGuessRows to 0 and ImportMixedTypes to Text in the registry, you should get the behavior you are expecting. You might, however, consider using a suitably large number like 1000 instead of zero if you find import performance to be less than ideal.

~

Just to note for anyone looking at this, if you use a 64 bit machine then you need to add Wow6432Node into the registry key so it becomes:HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.‌ 0\Access Connectivity Engine\Engines\Excel – amarsuperstar Jul 6 '11 at 17:14
	I edit Registry, based on this link. It works in window xp but doesn't work in window 7. Do I need to putWow6432Node in the registry key for 32 or 64 bit? – soclose Jul 12 '11 at 8:30
1	@soclose The HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node key is only present on 64-bit Windows installations. en.wikipedia.org/wiki/WoW64  ~