Export from Access 02 to Excel 02

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

I am trying to export a report to an excel spreadsheet (both XP)
I am using the OutPut To Method

DoCmd.OutputTo acOutputReport, "rptListAccreditedVeterinarian", "C:\Test.xls"

I am getting several errors, the main one being cannot find the '|' object? All other export functions work ( to a TXT, RTF etc.)

Any suggestions?

Carlee

I keep getting the error
 
Export the query or table. The report isn't actually data and thus does not
exist.
--
G Vaught

Carlee said:
Hi everyone,

I am trying to export a report to an excel spreadsheet (both XP)
I am using the OutPut To Method

DoCmd.OutputTo acOutputReport, "rptListAccreditedVeterinarian", "C:\Test.xls"

I am getting several errors, the main one being cannot find the '|'
Click to expand...
object? All other export functions work ( to a TXT, RTF etc.)
 
Try adding the output format to the code.

DoCmd.OutputTo acOutputReport, "rptListAccreditedVeterinarian",
acFormatXLS, "C:\Test.xls"


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Carlee said:
Hi everyone,

I am trying to export a report to an excel spreadsheet (both XP)
I am using the OutPut To Method

DoCmd.OutputTo acOutputReport, "rptListAccreditedVeterinarian", "C:\Test.xls"

I am getting several errors, the main one being cannot find the '|'
Click to expand...
object? All other export functions work ( to a TXT, RTF etc.)
 
Back
Top