PLEASE HELP with exporting data to Excel

  • Thread starter Thread starter Shadow
  • Start date Start date
S

Shadow

Is there anyway to export/output the data of a from to a specified sheet of
a specified excel file?

This is my situation:
I have a form based on a query that shows the result of a search. I need to
export this search result to the end of a list in sheetOrders of Orders.xls

DoCmd.OutputTo acOutputForm, "Orders", _
acFormatXLS, "Orders.xls", True

the above code output the data to a new book. How can I change this code to
output the data to the end of a list in sheetOrders sheet of an existing
Orders.xls book?


I appreciate any kind of help.
 
Link to SheetOrders in Orders.xls. This will create an Access table. Create an
append query based on your form's query and append the data to the Access table.
Through the link, this will also add the search result to the end of a list in
sheetOrders of Orders.xls.
 
thanks for the hint. Isn't there any solution to do it through visual basic?

I appreciate your help.



shadow
 
DoCmd.OpenQuery "NameOfYourAppendQuery"


Shadow said:
thanks for the hint. Isn't there any solution to do it through visual basic?

I appreciate your help.



shadow
Click to expand...
 
Back
Top