Referencing External Data

  • Thread starter Thread starter Smiley
  • Start date Start date
S

Smiley

I have a dataset that is larger than what Excel can hold. (Approx 85,000
records). I have this stored in an Access table and would like to reference
this data from a formula on the Excel spreadsheet. Is this possible??? (I
do not use pivot tables because they are crap and have very limited
functionality and flexability.)
 
You could use MS Query to query the Access table to limit the return data.
 
You must log in or register to reply here.

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

Excel Pivot Tables 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How can I change the source data reference to another pivot table? 2
dynamic data range in pivot tables excel 2007 1
Pivot Tables & External Data 1
Excel Import External Data by Date Automatically 0
Can we connect Pivot to multiple source data (MS Access) 6
Referencing a pivot tables Grand Totals Column 1

Back
Top