Access query in excel

KenHigg

Registered User
Local time
Today, 18:32
Joined
Jun 9, 2004
Messages
13,310
When I embed an Access query that has parameters into excel it does not appear to bring in the data -Any ideas?
 
Best I can research it can't be done - :)
 
not sure exactly what you are trying to do, but if you have a query in Access, you can bring the data that it produces into Excel by going to Data tab (in Excel) then selecting 'From Access', etc, then use this data connection in Pivot Table.
 
Thanks for the responses - I'll give them a look!
 

Users who are viewing this thread

Back
Top Bottom