[RESOLVED] CSV oledb issues

Hmm. quite odd.

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

Heading:

Code:

---

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

---

Data:

Code:

---

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:

Code:

---

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

---

thoughts?

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"