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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table from Access DB
What's the exact error message?
"dale1948" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table from Access DB
Tim,
Following are the exact steps I took after creating the MS Access database table. 1. From Excel, select Pivot Table 2. Select External Data Source 3. Get Data 4. Choose Data Source, I selected MS Access 5. Select Database, I selected the .mdb file I created 6. Add table, I selected the table which I called "2007YTD" 7. A window entitled Microsoft Query opened with the message "Can't access table 2007YTD". "Tim Zych" wrote: What's the exact error message? "dale1948" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table from Access DB
I can't replicate your problem, however there are a handful of links on the
MS support site that might offer something: http://support.microsoft.com/search/...de=r&cat=False "dale1948" wrote in message ... Tim, Following are the exact steps I took after creating the MS Access database table. 1. From Excel, select Pivot Table 2. Select External Data Source 3. Get Data 4. Choose Data Source, I selected MS Access 5. Select Database, I selected the .mdb file I created 6. Add table, I selected the table which I called "2007YTD" 7. A window entitled Microsoft Query opened with the message "Can't access table 2007YTD". "Tim Zych" wrote: What's the exact error message? "dale1948" wrote in message ... 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? |
Reply |
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) |