Date Format

Mjoza

Board Regular
Joined
Aug 31, 2011
Messages
172
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
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,857
Office Version
365
Platform
Windows
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

Board Regular
Joined
Aug 31, 2011
Messages
172
Thank u guys. I will try that.
Joe, yes the dates are text in excel.
 

Forum statistics

Threads
1,086,254
Messages
5,388,700
Members
402,136
Latest member
Miki

Some videos you may like

This Week's Hot Topics

Top