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.
 

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

make-table 1
Query Too Complex 8
Make table query won't run but Select will 3
query links to SQL server and mdb table 1
automate a make table query 5
Automate question answers in make-table query 1
Make table query: [Enter 1] AS Test 1
update query vs make query 5

Top