Running Queries and Importing data

N

Nicholas Noone

This is going to be a rather long question... So I hope
someone can help me with this.

I am setting up a database that will pull information from
3 different networks and marry them into one. Due to the
fact that on each network the info I am working with
(ODBC) is named the same I can not import all 3 directly
into 1 database. I have setup 3 databases, 1 on each
network and have queries generated to pull the info I need
into tables. I plan on linking my main database to these
tables for their information. However, I am looking for a
way to have these databases queries automatically run
without having to manually open each database. I tried
setting up a command window that would simply open the
database, then the macro in that databse would run the
query and close the database. My main database would now
be ready to work with this updated data. The command idea,
however did not work. It's possible I was attempting it
from the wrong angle. If anyone has any ideas or
suggestions on what I can do... I greatly appreciate it.

Have a great day!
Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Clearing combo boxes and a text box 2
Active Content in this file is blocked issue 1
Setting column width in a table with a macro is not working 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Page numbering with Merged Document and IF statements 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1

Top