CSV PROBLEM

[dskpgt@rediffmail.com]

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,8 9127,0,Hu,VID,S uccess,1,64,56, K,250,*
5/10/2006,07:39:31,9 ,0,Nabeel,VID,F ailure,0,17,64, K,250,*
5/ 9/2006,20:12:55,8 6411,0,Muni,VID ,Success,1,75,7 6,K,250,*
5/ 8/2006,08:22:13,1 0,0,Faqir,VID,S uccess,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

[cj]

Re: CSV PROBLEM

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.

dskpgt@rediffma il.com wrote:[color=blue]
> 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,8 9127,0,Hu,VID,S uccess,1,64,56, K,250,*
> 5/10/2006,07:39:31,9 ,0,Nabeel,VID,F ailure,0,17,64, K,250,*
> 5/ 9/2006,20:12:55,8 6411,0,Muni,VID ,Success,1,75,7 6,K,250,*
> 5/ 8/2006,08:22:13,1 0,0,Faqir,VID,S uccess,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
>[/color]