View Single Post
 
Old April 14th, 2008, 03:19 PM
gfranco gfranco is offline
Authorized User
Points: 185, Level: 3
Points: 185, Level: 3 Points: 185, Level: 3 Points: 185, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: , , .
Posts: 26
Thanks: 0
Thanked 1 Time in 1 Post
Default Export query param from Access form 2 XLS template

Hi, I have an Excel template which contains a Pivot data which will be refreshing by a tab after i am exporting a query to raw data in the workbook.
E.G
raw-data (getting from query)
pivot-data (refreshed by query)

1) I would like to know how can I get the code for exporting the query on excel using parameters by Access form
2) How can i use the template file after the exporting to be refreshed on the pivot table.

I am really appreciate any help from you. I would prefer not using transfer method.

Thanks.