I am trying to import excel dates into access... excel dates are in
date and time format. but when i import into access, it is taking as
some text value and not as exact date.
Any idea on what should i do? please advise. thanks
The problem is that Access has strong datatypes, and Excel doesn't: it may
look like a date to you but Access might not interpret it as one.
One possible solution would be to have an existing Access table with the
date/time field already defined; you could then *link* to the spreadsheet
(rather than importing it) and run an Append query to populate the table.It
might even be necessary to put a calculated field
CDate([excel-date-field])
in the Query. If this doesn't work, post samples of the data as it existsin
Excel.
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see alsohttp://
www.utteraccess.com