Automate make table query

A

Allison

Is there a way to automate a make table query that is
linked to two different ODBC tables.
 
M

Mark

Allison,

What's your definition of "automate"? Please provide a
little more description of what you're seeking to do.

Mark
 
R

Rebecca Riordan

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

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
A

Allison

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.
 
Top