How to tell what table a make table query makes?

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I cant figure out how to find out the name of a table
that a make table query makes.

Please advise.
 
I cant figure out how to find out the name of a table
that a make table query makes.

Please advise.
Click to expand...

If you use the query design grid and select a Make Table query (by
clicking Query + Make Table Query) it asks you for the table name.
 
Switch to SQL view (select SQL View from the View menu) and look for the
name of the table immediately after the keyword 'INTO'.
 
You must log in or register to reply here.

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

Select Query Vs. Make-table Query 10
Make Table Query 2
Pass Through Make Table 7
Make table from recordset 2
Make table using Union Query 2
Make Table Query 1
Make Table query in VBA 17
Make table query 2

Back
Top