日期超出范围或格式无效。 （错误3175） [英] Date is out of range or is in an invalid format. (Error 3175)

问题描述

我正在将Excel数据导入MS访问Sharepoint链接表，并且我得到日期超出范围或者是12/31/9999日期的格式无效。我如何解决此问题？请帮帮我



我尝试了什么：



这是我的导入代码

DoCmd.TransferSpreadsheet acImport，acSpreadsheetTypeExcel9，TAMIT_NA_EMEA_Extract，strItem，True

解决方案

这似乎是SharePoint的限制。网络研究表明，在SharePoint表单中输入错误的日期会发出错误消息

Quote：

您必须指定一个有效日期在1/1/1900和12/31/8900范围内

因此，您必须检查Excel日期并将其限制在上述范围内，或确保Excel表格不包含此类日期。

I'm importing a excel data into MS access Sharepoint linked tables and i get the Date is out of range or is in an invalid format for a 12/31/9999 date.How can i fix this issue? please help me

What I have tried:

This is my importing code
DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9,"TAMIT_NA_EMEA_Extract", strItem, True

解决方案

It seems to be a limitation of SharePoint. A web research shows that entering wrong dates into a SharePoint form issues the error message

Quote:

You must specify a valid date within the range of 1/1/1900 and 12/31/8900

So you have to check the Excel date and limit it to the above range or ensure that the Excel sheet does not contain such dates.

这篇关于日期超出范围或格式无效。 （错误3175）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！