View Single Post
 
Old 06-22-2021, 03:31 PM
QNRyfzKPYQyC QNRyfzKPYQyC is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Jun 2021
Posts: 4
QNRyfzKPYQyC is on a distinguished road
Default did Office change? I get connection errors

Hi, have been trying to make this work on my mac but unfortunately without success. I've managed to connect to the file, but the sql-string seems te generate an error ("can't open data file" translated from dutch). I've simpified the sql from the tutorial above into

\s " SELECT [Subordinate Forename] FROM [Sheet1$] WHERE [Manager ID] = { MERGEFIELD Manager_ID } "

Still no luck. Please help.
test.docx

test.xlsx