eidt registry entry within .NET application

14 Sep 2006 11:54 PM

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

15 Sep 2006 3:24 AM

tomb

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

T

Bill Nguyen wrote:

Show quoteHide quote

>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
>
>
>
>

15 Sep 2006 3:33 AM

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

Show quoteHide quote

"tomb" <t***@technetcenter.com> wrote in message
news:L4pOg.6780$C26.2782@bignews6.bellsouth.net...
> Take a look at the Registry class in Microsoft.Win32 - it has everything
> you need.
>
> T
>
> Bill Nguyen wrote:
>
>>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
>>
>>