Allowing the user to select the table to import

[sunshine19]

I would like to allow the user to push a command button and import a table from one Access database to another access database. I am using an API call for the user to be able to select the access database in which the table exists but I am at a loss for how to allow them to select the specific table. I don't want to hard code the importing table name because it may change in the future. Is there an active x control that I could use or another api call? Any help would be appreciated.

 

[JonFer]

Why don't you just add the "Import" toolbar button to a toolbar? It does what you are trying to program already.

If you still want to program this, you can open the user-selected database within a Module, import the list of tables (from TableDefs collection) to a table in your starting database, close the selected database, and then provide the tables to the user in a list box.