Excel Data Connections to Access Queries: Limits?

F

funnybroad

I have an Access 2007 database with data connections to:
+ Sharepoint Lists
+ SMS SQL tables/views

I've written Access queries that use tables from those data connections.

I want to use Excel to connect to those queries in the Access database to
run various reports (such as charts, lists, etc...)

However, I'm having 2 problems:
1) In Excel, when I go to Data / Get External Data / From Access, I cannot
see all of the queries listed in the Access Database.
2) The queries I do see only return a small subset of records. (I've
tested the query within Access, and I should get 170 records. In Excel, I
only get 10 records).

Am I trying to do the impossible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access Query to import from Sharepoint 0
Embed the same Excel multiple times 0
Merging from an Excel file with graphics 1
InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
Creating a Chart on form from selected data in query. 0
Adding data to MS Access from csv file 0
Table Security in Access 2013 1

Top