eidt registry entry within .NET application

[Bill Nguyen]

I ran into Excel alphanumeric data column import using ADO.NEt.
Upon searching, I found this solution, but it requires edit a registry entry
as follow:
Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRowsThat
says how many rows to scan to guess the datatype. The default is 8, but you
can set it anywhere from 0-16 decimal (0 meaning "scan the first 16384
rows", and all other values meaning what they say). Putting this all
together, the most reliable way to read a US/Canadian postal code is to use
the following registry settings:

TypeGuessRows = 0
ImportMixedTypes = TextIs it possible to build a function to verify and edit
the registry in question?ThanksBill

 

[tomb]

Take a look at the Registry class in Microsoft.Win32 - it has everything
you need.

T

 

[Bill nguyen]

Tom;

I found the answer for registry editing.
however, the problem is still with ADO.NET for Excel exporting.
I don't know if this problem has been resolved with VS 2005/NET 2.0

Thanks

Bill