Default "Save As Type" when Exporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I periodically export a number of Access Tables to an Excel file. For each
table that I export, I need to change the "Save As Type" to Microsoft Excel
97-2003. It's a bit annoying and time-consuming. Is there some way that I
can change the default "Save As Type" to Excel, or get Access to default to
the last value selected (which, if I remember correctly, it did in previous
versions)?
Thanks for your help.
 
I don't think there's a way to change the default - but why not write a
VBA procedure that uses DoCmd.TransferSpreadsheet to do the exporting
for you?
 
Back
Top