• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 51
  • Last Modified:

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
0
Ron
Asked:
Ron
  • 2
1 Solution
 
hnasrCommented:
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
 
hnasrCommented:
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
 
RonBudget AnalystAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now