I have a crosstab query which i want to export, using a Macro, as an excel sheet to a specific folder (using TransferSpreadsheet or TransferText options in the Macro). Any ideas on how i fill in the required fields? keep getting the error "Cannot update: database or object is READ ONLY".
I have it working perfectly for Make table queries (using TransferSpreadsheet)and it emails me the link when the macro completes. I just want to add this crosstab query to the Macro so that it also exports.
Any help would be greatly appreciated!