Automate make table query

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

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

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

Mark
 
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...
 
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
query links to SQL server and mdb table 1
Make table query won't run but Select will 3
ODBC -- update on a linked table [table name] failed 1
Pass-Through Query / Multiple ODBC Connections 1
Data Not Displayed in Query 2
Make table query: [Enter 1] AS Test 1

Back
Top