Thanks Paul, that worked a charm. I could (and probably should) leave it
there - I recorded the steps and I can just drop them into my code as is.
But, I'm curious. Here's part of what I recorded ...
With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array( _
"OLEDB;Provider=Microsoft.AC
There are many, many (many) ways of retrieving data from a database.
What YOUR code:
Workbooks.OpenDatabase Filename:= _
"G:\Work Program\2015\Temp.accdb",
is doing is actually opening the actual database in Excel, instead of
retrieving the data.
Instead, you could try:
On a blank sheet (wi
