We have an Access 2010 Front end to SQL Server Backend Database here for 4 departments. There is a daily spreadsheet sent out from our Corporate HQ that is imported into this DB and the new data is this spreadsheet is added to our database. This worked flawlessly for the last year until this week. Over the weekend our SQL Server was upgraded from SQL Server 2008 R2 to SQL Server 2014 to accommodate a change at the corporate level. Now the daily spreadsheet fails to import the data with a data conversion error.
It looks to me like one field has the conversion error so I click on yes then I can query the data and see which field is the problem. However, none of the data is actually uploaded. I've checked the field types that are being updated and other than the field size they match. Access gives the text fields on the imported spreadsheet as 255 characters. None of the actual text fields are over 100 characters and all of the data in the spreadsheet is under the field length for each of the imported fields. The field types match with the exception of 2 fields in SQL Server they are binary MS Access shows them as yes/no. The data for those fields when displayed in Access is -1 and 0 when displayed in SQL Server is 1 and 0. Other than that I don't see any difference. Anybody have an idea? I've checked everything I can think of but still get the same error.