Is it possible to import the table design from a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm wanting to run an append query (into a new table) as opposed to running a
maketable query, due to 'temp disk errors' when attempting to run the
maketable. But before I run the append, is there an easy way to import the
table design into my new table from the query I'm about to run?
 
It's ok, have worked it out (via import option, definition only) Knew it was
there somewhere.
 

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

Queries losing fieldnames when importing from external mdb 2
run a macro via a query 1
Setting the Properties on a Table that was made by a MakeTable Que 3
Update query question 3
Pull a field from a form to be the criteria of an append query 0
Make table truncates text concatenated using fnConcatenate 1
Append Query Issue 0
Suppressing warning messages from MakeTable query 2

Back
Top