How to convert to date format

  • Thread starter Thread starter Metcare
  • Start date Start date
M

Metcare

Hi,

I received an EXCEL file that I need to manipulate in MS ACCESS and one
column has a date format like this:

ex:
20090220 - corresponding to Feb 20, 2009
20090131 - corresponding to Jan 31,2009

How do I format them so it can be converted to MM/DD/YYYY as I need this
format to be able to import and manipulate the column in ACCESS. Right now,
when I import the EXCEL file to ACCESS the data type for this column is
DOUBLE , and when I tried to change the date type to DATE/TIME, it deletes
the column.
Appreciate your help. Thanks in advance.
 
Correction to my post...
the data type when imported to ACCESS is NUMBER and fieldzise is DOUBLE
 
Hi,

In Excel select the column of dates and choose Data, Text to Columns, click
Next, Next and on the 3rd step select your date field in the Preview pane and
then open the date dropdown at the top and choose the order that matches your
dates YMD.

By the way dates should be stored in date fields in Access - that is in the
Table Design screen the field type for the Date feild should be Date!
However, you can't just change the data type in this case.
 
Thank you so much, It worked!

Shane Devenshire said:
Hi,

In Excel select the column of dates and choose Data, Text to Columns, click
Next, Next and on the 3rd step select your date field in the Preview pane and
then open the date dropdown at the top and choose the order that matches your
dates YMD.

By the way dates should be stored in date fields in Access - that is in the
Table Design screen the field type for the Date feild should be Date!
However, you can't just change the data type in this case.
Click to expand...
 
One way:

Select the Column. Choose Data/Text to Columns. Click Next, Next. Select
YMD from the Date dropdown. Click Finish.
 
Back
Top