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?