Code:
.OpenDataSource Name:=StrSrc, AddToRecentFiles:=False, LinkToSource:=False, ConfirmConversions:=False, _
ReadOnly:=True, Connection:="Provider=Microsoft.ACE.OLEDB.12.0;" & _
"User ID=Admin;Data Source=" & StrSrc & ";Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";", _
SQLStatement:=StrSQL , SQLStatement1:="", SubType:=wdMergeSubTypeAccess
With 'Format:=wdOpenFormatAuto' removed, things seem to work up until the line in blue.
It is with this that the mysterious select table appears.
When I had been testing, when this portion was not included, the line in green providing me with the select table dialogue in which I was able to select CORE.