[RESOLVED] CSV oledb issues

[Techno]

Hmm. quite odd.

I have this row of data (first line is heading):

Heading:

Account Number	Account Name	Account Status 	Account Address 1	Account Address 2	Account Address 3	Account City	Account Country	Account Post Code

Data:

ACA001	UPDATE	2	Centrum UPDATE	UPDATE	 	CITY UPDATE	COUNTRY 	1081 HV

it reads it fine but refuses to read the postcode (1081 HV)

just an empty string. no exceptions when reading the CSV.

connection string im using:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Text;HDR=Yes;IMEX=1;FMT=Delimited\""

thoughts?

[Techno]

fixed.

in registry modify this (for 64 bit OS... not sure about 32 bit)

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Text

Set "MaxScanRows" to 0 decimal and "ImportMixedTypes" to "Text"