I have 10 databases, each with the exact same query. I am needing to compile this data into excel for a vendor. I was thinking instead of having one massive spreadsheet with 10 individual queries, to run an append query in 9 of those databases and append all records to one "master" table and then from that table run one query!
My problem, I do not know how to append records to a table in a different database... Can someone please explain how to do this???
Also, if this is a crazy thought that I have, and there is an easier way to do what I need to accomplish let me know that as well.
Thanks Guys!!