By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

CSV date Field IMPORT Problem

P: n/a
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,2 50,*
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 on particular recordset

waiting for Urgent reply

Thanking You

DAs

May 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
AP
Ive run into this before, it looks like it is not recognizing the field
as a date because there is a space in the field. Try importing the
field as text to a temp table, then append from the temp table into
your final table, try using the cvdate() function to convert the dates
when you append.

May 15 '06 #2

P: n/a
I would think it's best to always import into a temp table. Assume imported
data is bad, until it is cleaned and checked. then append it you your
tables.

"AP" <ap******@thompsongroup.com> wrote in message
news:11**********************@j73g2000cwa.googlegr oups.com...
Ive run into this before, it looks like it is not recognizing the field
as a date because there is a space in the field. Try importing the
field as text to a temp table, then append from the temp table into
your final table, try using the cvdate() function to convert the dates
when you append.

May 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.