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

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?
 
G

Guest

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
Pull a field from a form to be the criteria of an append query 0
Setting the Properties on a Table that was made by a MakeTable Que 3
append query 5
query field names changing to expr#: 8
Access 2007 - append query only appending 0 rows??? 0
run a macro via a query 1
Defining Text field sizes in destination Make-Table Query 3

Top