| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table from Access DB
I'm dealing with a spreadsheet which will soon exceed the number of allowable
rows. I've found that using a Pivot Table is a great way to organize and analyze all of this data. I thought I'd be clever by importing the data to Access and create a table, then go into Excel run the Pivot Table using external data, select the table in my database, and do my thing. But, I get a query error in Excel saying it can't access the table. Why not? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you export a pivot table into Access? | Excel Discussion (Misc queries) | |||
| PIVOT TABLE FROM A FORM IN ACCESS | Excel Discussion (Misc queries) | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
| Pivot Table against an Access Database | Excel Discussion (Misc queries) | |||
Threaded Mode
