|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
CSV PROBLEMI 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. dsk***@rediffmail.com wrote: Show quoteHide quote > 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 > 
Other interesting topics
Storing collection of one class inside another
Server calls client behind firewall/NAT convert byte() in ASCII code to letters? Need one Regular Expression word automation bookmarks Access MDI child properties generically Setting Limitation to number of Rows in DataGrid? Raise Maximum Compiler Error Limit? Hide an application to taskbar by the clock Alert message box help |
|||||||||||||||||||||||
