kbWilliamson
Programmer
Any of you learned folk know of a way to cause Access to export a table (or query) to an Excel worksheet via a DAO or ADO command?
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 strongm 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 from VB
- Thread starter kbWilliamson
- Start date
- Status
First make a reference to the Microsoft Access Object Library then do something like this.
Dim AccessObject As Access.Application
Set AccessObject = New Access.Application
AccessObject.OpenCurrentDatabase ACCESSFILENAME
AccessObject.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblName", App.Path & "\Test.xls"
Dim AccessObject As Access.Application
Set AccessObject = New Access.Application
AccessObject.OpenCurrentDatabase ACCESSFILENAME
AccessObject.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblName", App.Path & "\Test.xls"
- Status
