You may receive a "Cannot update. Database or object is read-only" error message when you use the TransferSpreadsheet action

When you run a macro that uses the TransferSpreadsheet action to export a table or query to the Microsoft Excel file format, you receive the following error message:

This error message occurs when one of the following conditions is true:

• The file name is surrounded with quotation marks, for example "C:\Employees.xls".
• A carriage return/line feed (CTRL+ENTER) is at the end of the file name in the FileName property.

To avoid this error message, when you set the FileName property, insert only the path to the file that you want to export. Do not surround the path with quotation marks or end the line with a carriage return/line feed.

Steps to Reproduce the Behavior

1. On the Help menu, point to Sample Databases, and then click Northwind Sample Database.
2. Create a new macro called TestOutput as follows:

      Action: Transferspreadsheet
      Transfer Type: Export
      Spreadsheet Type: Microsoft Excel 8-10
      Table Name: Employees
      File Name: C:\Employees.xls (insert a carriage return/line feed at the 
                 end of this line by pressing CTRL+ENTER)
      Has field names: No
   					

For additional information about another cause of this error message, click the article number below to view the article in the Microsoft Knowledge Base: