DoCmd Questions (Preferences)

C

crossb

Hi,

Earlier I posted a msg asking if there is anything bad with using:
DoCmd.OutputTo acOutputQuery, "Reports_Query_Final",
acSpreadsheetTypeExcel8, strInputFileName

over the DoCmd.TransferSpreadSheet method. I found using the OutputTo
eliminated the 3160 error that I was getting.

Has anyone got any experience with this? Any input would be greatly
appreciated. I am using both Access 2000 and 2003.

Thanks!
 
C

crossb

Hi,

Thanks for the response. I'd like to switch back to
TransferSpreadSheet method if that is the case. When I do use it I get
error 3160... Does anyone why this happens and what do I do to prevent
it from happening?

Thanks!
 
Top