Connection to Excel from Access isn't working

[emtebbe]

I'm trying to pivot off of an Access query. I connect the query to the pivot table, and no data shows up. The column headings do, but there aren't any data points. When I run the query in Access, it pulls the correct data. Any ideas what's going on?

Thanks!

 

[Micron]

I'm trying to pivot off of an Access query. In where? This could be Excel pivot table, or you could mean you're using the TRANSFORM statement in Access. I connect (is this an ADODB or DAO connection? Or connect from where to where?) the query to the pivot table, and no data shows up. The column headings do, but there aren't any data points (so this is an Excel chart in a workbook?). When I run the query in Access, it pulls the correct data. Any ideas what's going on?
I'm confused as to what's going on. Can't decide if it's an Access query on an Access table, linked spreadsheet, pivot table in a spreadsheet...
Thanks!

Maybe you should post the code or sql involved.