VBA/Excel/Access/Word/Access/Table Output

Export table to html file

 
Sub OutputToHTML()
    DoCmd.OutputTo acOutputTable, "tblComplaints", acFormatHTML, "c:\s.html", True
End Sub

Output table to asp file

 
Sub OutputToASP()
    DoCmd.OutputTo acOutputTable, "tblComplaints", acFormatASP, "c:\t.asp"
End Sub