eidt registry entry within .NET application

  • Thread starter Thread starter Bill Nguyen
  • Start date Start date
B

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