View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Zych Tim Zych is offline
external usenet poster
 
Posts: 389
Default 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?