KenHigg Registered User Local time Today, 18:32 Joined Jun 9, 2004 Messages 13,310 Nov 6, 2013 #1 When I embed an Access query that has parameters into excel it does not appear to bring in the data -Any ideas?
When I embed an Access query that has parameters into excel it does not appear to bring in the data -Any ideas?
KenHigg Registered User Local time Today, 18:32 Joined Jun 9, 2004 Messages 13,310 Nov 6, 2013 #2 Best I can research it can't be done -
Rx_ Nothing In Moderation Local time Today, 16:32 Joined Oct 22, 2009 Messages 2,803 Nov 7, 2013 #3 http://microsoft1.software.informer.com/download-microsoft-excel-query-builder/ Felling adventurous?
L lemo Registered User. Local time Today, 18:32 Joined Apr 30, 2008 Messages 187 Nov 8, 2013 #4 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.
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 Registered User Local time Today, 18:32 Joined Jun 9, 2004 Messages 13,310 Nov 11, 2013 #5 Thanks for the responses - I'll give them a look!