append external table

[warrentogami]

Is there any way I could append an external table from another access database into a table in the current access database w/o copying and pasting?

 

[jsolutions]

Yes, you can create a link to the external database table. Then create an update query based on the linked table and update to the desired table.


Let me know if you have any questions.

Jay

 

[warrentogami]

the only thing is I have multiple tables and I don't want to keep linking tables and then appending them. this is because i have a daily table and after every day, i want to append that daily table to a history table for 12 different tables, so i have two databases, one for the history and one for the daily. i didn't want to combine the two because it will be too confusing for users to use

 

[jsolutions]

I want to see if I understand what you are asking.

The data in the daily table is what you want to append to the other tables, correct?

The daily table is in the database that you are using, correct?

The tables that you want to append to are in the external database, correct?

Let me know the answers to this and we can move forward with a solution.

Jay

 

[warrentogami]

correct

 

[jsolutions]

If this is correct, then you need to create an append query (Select Append from the query menu) in the current database based on the daily table. You will be prompted for the table that you want to append and you will have two options : Current DB or External DB. Select External and navigate to the DB. You will then be prompted for the table in the external DB.

When you run the query, the data in the external database will be appended.

If you need to manage this through code, use the docmd.runquery qryname.

Note The user will be prompted that X records are about to be appended to a table. If you do not want the user to see these messages, set showwarnings to false.

Let me know if we are on the right path here. I hope I have understood you question.

If you need any clarification, let me know.

Jay