Append FROM one database to another

[JRodko]

Hello,



Struggling with this. I have experience appending TO another database (Database 1 Append TO Database 2 from within Database1), but I am trying to change this up for a few reasons I won't get into.

Is there any way to Append FROM Database1 To Database2, but from within Database 2? Another way to look at this would be to import from database 1 into database 2. I have tried the import from database but that keeps just duplicating the entire table which is useless to me. To make things further complicated, I'd like to be able to set query parameter. So it will only import records where [Parent-ID] = Whatever is defined.

Can this be done? I feel like it can be done via SQL?

[ranman256]

link the external table db1.table1 into db2.
run append query.

[JRodko]

link the external table db1.table1 into db2.
run append query.

yup, right in front of me the whole time.