When linking to a table via ODBC to a SQL database, Access returns any field that is formatted as 'Date' as a 'Text' field. A Date/Time field works fine. I cannot change the SQL Database.  Is there a fix for this?

Hi,

In regarding of the issue, please provide us more information to assist you better.

• Which version of Access and SQL server do you use?
• Do you use ODBC Driver 11 for SQL server?

Based on my test (My environment: Access 2013, SQL server 2014, and ODBC Driver 11 for SQL server), I can't reproduce your issue. Regardless  of "Date" and "Date/Time" data type of SQL, both of them can be linked to Access that are formatted as Date/Time type.

I suppose this issue may be caused by the data. For example, if the date like: 2015--2--23, it can't be recognized as date type in Access. Please try to check it.

If you have any update, please feel free let me know.

Regards,

George Zhao
TechNet Community Support