I am using Excel VBA and have a statement that runs a MakeTable query. This is run successfully, however when I try to use that new table inside the code after it is created, it shows the following error:
The Microsoft Access database engine cannot find the input table or query, 'myNewTable'. Make sure it exists and that its name is spelled correctly.
Is there a way to refresh the database (F5 equivalent) in Excel VBA?