Connecting Excel to Access Back End

I have an Access database which has three linked tables from Excel as Input Sources. There are some queries that combine the data and I have two queries that are my outputs.

My intention is to have an Excel workbook that connects to the Access queries as data tables in Excel. One of my output worksheets successfully finds a Select Query in Access and returns the records into Excel. The other worksheet does not.
I'm trying to connect the other worksheet to a Subtotal Query in Access via the Get Data wizard Get Data>From Database>Microsoft Access Database and then connect to the  aggregate query in Access but the query returns no records, even though the query has records in Access. Even in the Excel preview wizard there appear to be no records. I did get it to work using the old method: Get Data>From Other Sources>From Microsoft Query>Choose Data Source>MS Access Database  and then browsing to the subtotal query and connecting to it.

Does anyone understand why the old method works but the new Get Data dialog doesn't when connecting to a subtotal query in Access?

Thanks
DavisroBudget AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hamed NasrRetired IT ProfessionalCommented:
Get Data>From Database>Microsoft Access Database and then connect to the  aggregate query in Access but the query returns no records,

Unable to reproduce the issue, the step is working fine with me.

Try it with a simple database, it may be a database issue rather than a connection.
0
Hamed NasrRetired IT ProfessionalCommented:
If still not resolved, try to recreate the issue with a simple database and a worksheet. If issue persists, upload the simple database and worksheet to check.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DavisroBudget AnalystAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.