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:
Printable View
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:
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")
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.
I got it.
Thanks.:beerchug:
You're Welcome :beerchug:
Take Care