Thread: export
View Single Post
  #1  
Old September 30th, 2004, 01:00 AM
external usenet poster
 
Posts: n/a
Default export


Hello I am using this VBA comand to attempt to copy an
access table to excel. It contiuously gives me an error
that it cannot find the the Object. The object I am trying
to export is an access table, which is called "Credit
Table" and I am using the Form to allow the user to choose
which table to export (the reason for the Forms!Ins!CQ
section)

do I need to add something to specify that it is a table I
am exporting.

DoCmd.TransferSpreadsheet acExport, , _
Forms!Ins!CQ & " Table", "C:\Actual \Trend.xls"