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

Export table to html file

   <source lang="vb">

Sub OutputToHTML()

   DoCmd.OutputTo acOutputTable, "tblComplaints", acFormatHTML, "c:\s.html", True

End Sub

</source>
   
  

Output table to asp file

   <source lang="vb">

Sub OutputToASP()

   DoCmd.OutputTo acOutputTable, "tblComplaints", acFormatASP, "c:\t.asp"

End Sub

</source>