Database Queries/Date Formats

  • Thread starter Thread starter daver676
  • Start date Start date
D

daver676

I am importing columns from an Access table using MS
Database Query. The date format in the database is YYMMDD,
so the query brings the date into the spreadsheet as the
same. (ex. 880321). When I attempt to format the cells as
a date in Excel, the formatting doesn't work, and the date
stays in the same format. Why? And how can I get around it
using Excel? Thanks.

Dave
 
Check the Access table, is the Date field set to a Date/Time datatype?

My guess is not. You can remedy this in Excel or in Access with a date
formula.

P
 
In Excel, you can use Text to Columns:

1. Select the column with dates
2. Choose Data>Text to Columns
3. Click Next, click Next
4. In step 3, choose YMD from the Date dropdown.
5. Click Finish.
 
Back
Top