import tables in to access from another access database
Dear Access Gurus,
Please help me to come out from below situation.
Have the database Total
- Containing the data that is coming from another databases
1. Source_A.mdb
2. Source_B.mdb
how to auto import the tables from source_a and source_b to datase total.
Source_A and Source_B contain the same table names, but while they importing to Totabl.mdb want to add the _A at the end of each table name.
Advice how to achive this.
Regards,
I am not sure I understand exactly what you are trying to do. Do you wish to import the data into a new table in the Total db or into an existing table? I am confused by your request. When you say automatically, are you looking for Access to do this with out any prompts or are you looking to have it done based upon an execution of a command button. Please clarify what you mean by automatically.
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks