Export Passthrough to excel

[hwkranger]

I'm not sure if this is the correct place to ask this question,


But how do I export a passthrough query to excel?

I keep getting the following error:

Operation is not supported for this type of object.

Code:

DoCmd.TransferSpreadsheet acExport, 7, tmp_qryName(i), str_ExportFileName

Randall Vollen
National City Bank Corp.

 

[tol514]

Don't know whether you tried TOOLS/OFFICE LINKS/ANALYZE IT WITH MS Excel. This will take the output and write it to an XLS sheet. You should save as to your xcel documents.

 

[hwkranger]

I want this as an automated process. That works - Just how do I do that in VBA?

(I'll probably figure that out before someone posts, but please leave suggestions reguardless)

Randall Vollen
National City Bank Corp.

 

[PHV]

Have you tried the DoCmd.OutputTo method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hwkranger]

Is there a way to output multiple queries to the same file on separate sheets via that method? I couldn't figure it out.

Randall Vollen
National City Bank Corp.