Export to Excel - how do I disable backup creation field?

[Rhorn4801]

When exporting from Access 2007 to Excel 2007, the spreadsheet created has
the "always create backup" box checked - this is found in the "Save AS"
"Tools" "General options" box. Is there a way to set Access2007 to NOT
activate this option when a query is exported to Excel 2007?

 

[Mark A. Sam]

I exported a query to Excel2007 from Access2007 and didn't see any "always
create backup" option. From Excel I selected the "Save As" menu selection
after I did the export. Can you try to explain your steps a little better?

God Bless,

Mark A. Sam

 

[french828]

Let me see if I can help:

When you are in Excel 2007 and it is automatically creating a backup, you
fix it by:
1) Windows symbol
2) Save As
3) Excel Workbook
4) Click "tools" at bottom left
5) Click "General Options"
6) Uncheck "Always create backup"

The problem is that when you are in Access 2007 and you are exporting a
query to Excel 2007 in the 2007 format (not 97-2003), it automatically
creates a backup. Is there a way to change the export feature in Access so
that Excel won't automatically create a backup? Obviously we can resave it in
Excel and uncheck "Always create backup", but it would be nice to not have
to.
It won't create a back up if you export it in 97-2003 format.