Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Export Access table to Excel
To export it and save it in a specific directory, you can also do: DoCmd.OutputTo acOutputForm, "Name", acFormatXLS, "c:\Documents and Settings\My Documents\Name.xls", True This should open Excel with the table displayed. After that, I'm not sure if you switch to an Excel macro to do the rest...- peacesine
- Post #13
- Forum: Microsoft: Access Other topics
-
Export Access table to Excel
Here's a start on exporting a table to excel: Private Sub Command0_Click() DoCmd.OutputTo acOutputTable, "NameOfTable", acFormatXLS, "NameOfTable2.xls", True End Sub I found it in Visual Basic Help, did a search for "OutputTo Method"- peacesine
- Post #6
- Forum: Microsoft: Access Other topics
