Category "openrowset"

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"

I'm trying to run the following statement but am receiving the error messages just below. I have researched answers to no end and none have worked for me. I'm

SELECT FROM OPENROWSET( BULK...) changing special characters

I've been facing an issue for a few hours, and I can't seem to get my head around this one. So I have a SQL Server database 2008R2, Collation SQL_Latin1_Genera