PDA

View Full Version : Solved: Date and time conversion from Excel to Access



Mr Doubtfire
04-22-2005, 12:49 PM
Two columns - Date column (20-Apr-05 - date format) and time (14:14:14 in text) from Excel, how I could convert them into Access 2003 date format (Thu Apr 21 14:14:14 EDT 2005)

Thank you in advance.:friends:

Jacob Hilderbrand
04-22-2005, 12:56 PM
Well is you have the date/time in Excel you can specify the format.

If x = your date/time value

Format(x,"ddd mmm dd hh:mm:ss " & """" & "EDT" & """" & " yyyy")

Mr Doubtfire
04-22-2005, 03:36 PM
Thank you for the suggestion.
" If x = your date/time value
Format(x,"ddd mmm dd hh:mm:ss " & """" & "EDT" & """" & " yyyy") "
The solution seems to be an Access coding.
Could you please tell me how I could combine the two Excel columns (date and time) and the procedure to reach the final Access date column?
I am new to do the Access conversion. Thank you again.

Mr Doubtfire
04-22-2005, 06:31 PM
I got it.

Thanks.:beerchug:

Jacob Hilderbrand
04-22-2005, 06:35 PM
You're Welcome :beerchug:

Take Care