How to organize saved exports in Access 2010

PattyAcc
PattyAcc used Ask the Experts™
on
I have a lot of "saved exports" in Access 2010.  I want to organize them alphabetically or some easy way.  But I can't figure out how to do it--it's definitely not putting them in alphabetical order.

Any ideas of how I can do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try using a query as your data source, order the records as desired in the query, and export that.

Author

Commented:
I believe you misunderstood what I'm referring to.  In Access 2010, once you export data you have the option to save the steps, so you don't need to keep inputting the file name, etc.

Access puts these "Saved Queries" into a place called "Saved Exports" (found on the "External Data Tab" on the ribbon.)

I want to organize these saved exports by name, so the ones I use for a particular task are all listed together.  It does not organize these in alphabetical order.

That's what I need to do.
Hmmm.....I did misunderstand the issue.  The only thing I can think of at the moment is that maybe your issue is one of the fixes implemented in Office 2010 SP1.  If you haven't already installed SP1, check this link out:
                           http://support.microsoft.com/kb/2460049

Example of issues fixed:
¿Fixes an issue that occurs when you try to export an Access file to an Excel workbook.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
AFAIC, there is no way to do this...

It seems that Access sorts them in the order that you created them.

Author

Commented:
Yes, that's what it seems like.  That's a real flaw as you should have the ability to sort them in some meaningful order so it's easy to use.
MIS Liason
Most Valuable Expert 2012
Commented:
Remember, years before this feature was ever created, Exports were "saved" by using code.

ex:
DoCmd.TransferSpreadsheet acExport, , "YourTableOrQueryName", "C:\YourFolder\Yourfile.xls", True

So you could put all of your individual Export codes on individual buttons on a form and "organize" then in any way you like.

Then simply click and export...

The benefit to using code is that you can easily "Edit" your export without having to recreate a new Export Spec...
Also the code will be attached to the form, so if you export the form to a new DB, the code will be there too.
Not sure how "portable" an Export Spec is...
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

Thanks!

Jeff

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial