Hello. I am trying to export several Access 2003 select queries to Excel 2003 using an Access macro. However, I have tried using the macro command “TransferSpreadsheet” and am receiving the error “Cannot update. Database or object is read-only”. Per the user/group settings any user has read/write access in the database. I also tried the macro command “OutputTo”, however I can determine who to output to a specific worksheet in the workbook.
Any help would be GREATLY appreciated. Thanks in advance.
