Link to home
Start Free TrialLog in
Avatar of shambalad
shambaladFlag for United States of America

asked on

Looking for a list of Saved Import/Export objects in Access 2007

In Access 2007 I can run a 'saved import' using the DoCmd.RunSavedImportExport method.
Is there some way I can retrieve a list of my saved imports? I've looked through the system files and don't see anything there.
Thanks,
Toddd
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shambalad

ASKER

Actually, I was looking for a way to do this in code, which I didn't say in my original question, so I'll give you the points on this.
By the way, I did find the answer:

The specifications have been moved from system tables to a collection in A2007.
CurrentProject.ImportExportSpecifications
The way to retrieve the list is to loop though the collection.

Thanks,
Todd