New Zealand's new Copyright Law presumes 'Guilt Upon Accusation' and will Cut Off Internet Connections without a trial. is against this unjust law - help us

A Space for All Things .NET Related

ODBC Provider Bug?

By James Hippolite, in , posted: 1-Dec-2008 08:39

ODBC Provider Bug?
James Hippolite
Friday 28-Nov-08 09:45

Has anybody heard of a bug in the ODBC provider for Excel where, if a column has 10 NULLS in a row, then the entire column comes in as NULL?

Paul Bibby
Friday 28-Nov-08 09:57

Don’t know if this is similar to your experience ?

Leigh Hunt
Friday 28-Nov-08 10:40

I ran in to I think the exact same issue a number of times years ago, importing mixed field types from Excel into Access, using the JET driver.

I think Paul's answer is probably the one your after, especially the links to and;en-us;257819.

However, I encountered mine about 8 years ago, using older versions of the software, so thought I'd post it here incase the above solutions don't fix it for you... (I notice one article states that the MaxScanRows argument doesn't work in a connection string - well it certainly works in the registry:

I changed the following entries in the registry:



After this, all imports would work fine for me.


Other related posts:
Delivered my Quality Presentation Again
The Microsoft Sync Framework
What's New in Microsoft SQL Services - My DNUG Presentation

Add a comment

Please note: comments that are inappropriate or promotional in nature will be deleted. E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.

Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.

Your name:

Your e-mail:

Your webpage:

JamesHip's profile

James Hippolite
New Zealand

Welcome to my technical blog. 

Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996.  This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog.  But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".