Probably, but you're going to need to be a little more specific about what
"automate" means. Do you mean run automatically? If so, under what
circumstances? Or do you mean that you want to automat having it run
against the two dbs?
--
Rebecca Riordan, MVP
Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
At a scheduled time each morning I would like to
automate/refresh the make table query in which two
separate tables are linked to an ODBC something like a
refresh of the data because it changes @ 12:00 pm each
night through a batch process.