import tables in to access from another access database

**jsimha** · 12-16-2010, 11:22 AM

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,

**alansidman** · 12-16-2010, 05:31 PM

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.

import tables in to access from another access database

LinkBack

Thread Tools

Rate This Thread

Display

import tables in to access from another access database

Re: import tables in to access from another access database

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions