BobC,

DoCmd.SetWarnings False 'Off
Your TransferSpreadsheet line here
DoCmd.SetWarnings True 'On

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"BobC" wrote in message
...
I merely want to update the table to be used as an export to Excel using
TransferSpreadsheet. Each time it prompts for deleting old records and
adding new records. Is there a was to turn off the prompts?
Bottom line - I want to create an Macro to export the output of a query to
an Excel spreadsheet.