transfer table into another table but in different database 1

[danielcan]

Good day to you all.

I am currently in my last mile for my project. what would be the code or macro to saved the data I just entered in my table and to save it into another table in another database.

I hope that does not sound to confusing.
thank you

 

[dhookom]

You can link the table from your other database/mdb into your current database/mdb. Then run an append query of your "data I just entered in my table" into your linked table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ByteMyzer]

Here is the SQL syntax for an append query to a table in an external database:

INSERT INTO [MS Access;Database=[i]filepath[/i];].[[i]table[/i]]
SELECT *
FROM [[i]table[/i]];

Example:

INSERT INTO [MS Access;Database=C:\MyFolder\MyExternalDb.mdb;].MyExternalTable (Field1, Field2, Field3)
SELECT MyTable.Field1, MyTable.Field2, MyTable.Field
FROM MyTable;

Example (password-protected external database):

INSERT INTO [MS Access;Database=C:\MyFolder\MyExternalDb.mdb;PWD=Mypassword;].MyExternalTable (Field1, Field2, Field3)
SELECT MyTable.Field1, MyTable.Field2, MyTable.Field
FROM MyTable;