Date Format

[Mjoza]

Hi everyone.

Can someone please help me. I imported data into access from excel and one of the fields in the new table has date as for example Jul-13 as a text format. Is there a way to convert to normal date?

thanks

 

[farmerscott]

Mjoza,

check out Risk's suggestion in-

http://www.mrexcel.com/forum/excel-questions/715361-format-date-text-date.html?highlight=date+format

also try

How to Convert Text to Dates [Data Cleanup] | Chandoo.org - Learn Microsoft Excel Online

FarmerScott


FarmerScott

 

[Joe4]

Can someone please help me. I imported data into access from excel and one of the fields in the new table has date as for example Jul-13 as a text format. Is there a way to convert to normal date?

It sounds like your dates are probably formatted as Text in Excel, which is why they are also Text when they get to Access.
There are way do it in Access, but it is a bit cumbersome because you would either need special VBA code to try to change data types and values, or use multiple tables (import to a temporary one, and write to a permanent one).
The easiest thing to do is convert them in Excel before exporting to Access, using the methods that farmerscott posted.

 

[Mjoza]

Thank u guys. I will try that.
Joe, yes the dates are text in excel.