如果您在 SQL Server 中将日期存储为数据类型Date"或Date2"，请尝试将它们更改为DateTime" 我在链接数据时遇到了这个问题从SQL server 2008R2到access 97，access没有把它看成日期，把它当成文本处理

If you are storing the dates in SQL server as the data type "Date" or "Date2" try changing them to "DateTime" I had this problem linking data from SQL server 2008R2 to access 97, access did not see it as a date and treated it like text