Query append data from another database

[Eagle2012]

Hi,


i have a database X,
i want to append data from tables in another database Y, into database X (tables in both databases have the same name: [Y].[Names] into [x].[Names]).
My question is:
- How to make this happen by allowing me to search for Database Y
(like if i want to save a Word file, a window will open to help me searching for the folder i want to save the Word file in).

Thanks in advance.

[orange]

Your request does not have any context. Please gives us a description of what you are doing or trying to do and why you have chosen this approach.
In order for people here to help you, we have to understand your environment and the issue.

[Eagle2012]

Hi,
i have a database X,
i want to append data from tables in another database Y, into database X (tables in both databases have the same name: [Y].[Names] into [x].[Names]).
My question is:
- How to make this happen by allowing me to search for Database Y
(like if i want to save a Word file, a window will open to help me searching for the folder i want to save the Word file in).

Thanks in advance.