CSV PROBLEM

  • Thread starter Thread starter dskpgt
  • Start date Start date
D

dskpgt

Hi

I have to Import some date values from a CSV file in to ACCESS 2003 .
the Data in the CSV files as


5/11/2006,10:14:52,89127,0,Hu,VID,Success,1,64,56,K,250,*
5/10/2006,07:39:31,9,0,Nabeel,VID,Failure,0,17,64,K,250,*
5/ 9/2006,20:12:55,86411,0,Muni,VID,Success,1,75,76,K,250,*
5/ 8/2006,08:22:13,10,0,Faqir,VID,Success,1,99,52,K,250,*

like that But the records on 5/11/2006 and 5/10/2006 are easily
imported in to access.
but 5/ 9/2006 & 5/ 8/2006 are not importing.

in report error table shows that Data type conversion error

why this happens?

In VB it also shows NULL in field of Date while retrieving the
recordset using ADO on particular recordset( 5/ 9/2006 & 5/ 8/2006 )

waiting for Urgent reply

Thanking You

DAs
 
I think if it were 5/09/2006 or 5/9/2006 you wouldn't have any problems
but with the space before the 9 it is an invalid date.
 
Back
Top