Reading an Excel database from Word using VBA

[gmayor]

That looks like one of my code sequences and the original should work if you have the Microsoft ACE driver installed
https://www.microsoft.com/en-us/down....aspx?id=23734
and of course you supply the macro with the full path of the Excel file and the worksheet name.