View Single Post
  #1 (permalink)  
Old February 6th, 2006, 10:45 PM
jcharlton jcharlton is offline
Registered User
Join Date: Feb 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Export Access Paramter Query to Excel


I have used Access for quite a while, but I am new to Visual Basic. Right now, I am trying to Automate my database by exporting the results of a parameter query to Excel. The criteria for the parameter query is based on a combo box I have loaded onto the form. How do I execute the parameter query (based on my combo box) and have the data automatically exported to an Excel template I have already created? I would like to automate this as much as possible with the combo box and parameter query. Thanks.