Access query in excel (1 Viewer)

[KenHigg]

When I embed an Access query that has parameters into excel it does not appear to bring in the data -Any ideas?

 

[KenHigg]

Best I can research it can't be done -

 

[Rx_]

http://microsoft1.software.informer.com/download-microsoft-excel-query-builder/
Felling adventurous?

 

[lemo]

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.

 

[KenHigg]

Thanks for the responses - I'll give them a look!