Export to Excel

[Phil Hunt]

What it the DoCMD to export a query to excel.

Thanks

 

[Bas Cost Budde]

TransferSpreadheet

What it the DoCMD to export a query to excel.

Thanks

 

[Phil Hunt]

thanks. I did some homework and come up with docmd.OutPutTO, any difference
b/t them ?

 

[Bas Cost Budde]

Basically, OutputTo creates a file from something outputted, whereas
TransferSpreadsheet creates a file meant for processing.

thanks. I did some homework and come up with docmd.OutPutTO, any difference
b/t them ?

 

[Phil Hunt]

thanks

Basically, OutputTo creates a file from something outputted, whereas
TransferSpreadsheet creates a file meant for processing.