Solved: Date and time conversion from Excel to Access

[Mr Doubtfire]

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.

[Jacob Hilderbrand]

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]

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]

I got it.

Thanks.

[Jacob Hilderbrand]

You're Welcome

Take Care