Access Tables not using Excel formatting

[kevindub]

I'm bringing in data from a Access Database to Excel and it come in a table. One column is a date field, the problem is that the date is showing up as text rather than a date. So it will look like a date but it doesn't have the formatting to go with it. If I go edit the information it comes out as a date. The problem to that solution is that the content gets updated every time the file is open and reverts the data back to text.

I"m sure that this issue has been addressed some where, and any help would be greatly welcomed.

[Norie]

How are you importing the data into Access?

Does the problem column have anything else, including empty cells, in it apart from dates?

[kevindub]

It was set up with an SQL server connection.

There are no blanks for the data. It's a mandatory field in the form.

[Norie]

Sorry I don't follow.

You are trying to import data into Access from Excel and the data has been imported from SQL server to Excel?

Why the 'middle man' Excel?

Also, what form are you referring to?

Forms don't store data so you can't import data to them.

[kevindub]

The access database is a web app hosted on office 365. I'm importing data from that database into excel to do reports. The date field is coming across as text not as a number.