Unable to import dates in the heading

[Tony Bender]

Whenever I import an Excel file with dates as headings, the result
shows the dates as text instead of date.

For example the heading in the Excel file reads: 1/4/2007, but when I
import this the heading in Access shows 39086.

How can I correct this?

Thank you,

 

[Jeff Boyce]

Tony

If you are importing Excel data into Access, that data is probably ... a
spreadsheet! Access is a relational database, not a "spreadsheet on
steroids."

You'll get a lot more use (and a lot easier use) of Access' features and
functions if you accept that the raw data from Excel probably needs some
additional parsing to get it into a well-normalized design. Create a
well-normalized, relational table design of your data (not your Excel
spreadsheet), then create a series of queries that parse the raw spreadsheet
import data into the appropriate more-permanent Access tables.

JOPO (just one person's opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP