DoCmd Questions (Preferences)

[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!

 

[Rick Brandt]

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!

One advantage of TransferSpreadsheet is that you can specify the Excel version.
OutputTo always uses Excel 97 format which doesn't support as many rows. Don't
know of any other differences off hand.

 

[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!