Import table with user prompts

[tweetyksc]

I have a database which I have automated to bring in and append text files to a table; this is working fine as it prompts the user to find the file and then it uses the import spec to append to the table. (using docmd.transfertext)

I'm now trying to do something similar, but by bringing in an Access table. I'm automating a database that someone else set up. There are 3 tables in the database which are updated bimonthly through new tables that are sent via email to users.

The 3 updated tables that are received by users are sometimes in one database, sometimes in 3 separate databases, so can't count on uniformity in name, etc.

Currently the tables are 1)imported as they are named (ex: ImportSales), 2) brought into the regular table through addendum query, 3) the imported table is deleted. Naturally, I want them to be able to just import the data into the regular tables without having to append, delete, etc.

What is the best way to do this AUTOMATED? I'm thinking transferdatabase but I'm not sure how to set it up in code for them to select each time the filename AND the table to be imported.

 

[FoFa]

There was a thread here I think just last week on reading table names frm an external table. Try searching for it.

 

[tweetyksc]

I did search before I posted my question.
I know how to do it if the name and location of the database you're importing from is already known; what I'm trying to do is figure out how to automate having a user select the location, name of the database, and the table, and have it come into a specific table. Table imported TO will always be the same. Where it's coming from will not.