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 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