1. Must enable 'show advanced options'
2. Make sure 'Microsoft.ACE.OLEDB.12.0' is ready in Provider of link server. Otherwise, download and install it. Note, I guess you need x64 version - AccessDatabaseEngine_X64.exe
Then, OPENROWSET should do its work.
GASQL.com - Focus on Database and Cloud