Solved

where Microsoft access 2013 stored all saved import names

Posted on 2014-12-21
4
519 Views
Last Modified: 2014-12-21
hi

i want to make a list on a form in Microsoft access 2013 with the all saved imports names, but i don't want to make a manually a list, it's there some way to with vba code the list of all import names

thanks
0
Comment
Question by:bill201
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40512219
look in
External Data > Saved Imports
0
 

Author Comment

by:bill201
ID: 40512223
thanks

i know it, but i want to know if it's store on a table or it's possible to get the list of import names with vba
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40512267
Sub getSIE()
Dim j As Integer
For j = 0 To CurrentProject.ImportExportSpecifications.Count - 1

Debug.Print Application.CurrentProject.ImportExportSpecifications.Item(j).Name
Next
End Sub
0
 

Author Closing Comment

by:bill201
ID: 40512463
thanks a lot
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question