Create table from query

's Computer Specifications

Using a macro how do you copy a query file and save it as a table file?
I know you can do it with the export drop down command picking the option to
save it as a table but how do you do it with a Macro?

's Computer Specifications

Gclute,

Make the query into a Make-Table Query (select Make-Table from the Query
menu in design view). Then use an OpenQuery action in your macro to run it.

--
Steve Schapel, Microsoft Access MVP

"gclute" <(E-Mail Removed)> wrote in message
news:0ACB355E-31CE-41B4-918A-(E-Mail Removed)...
> Using a macro how do you copy a query file and save it as a table file?
> I know you can do it with the export drop down command picking the option
> to
> save it as a table but how do you do it with a Macro?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create join between 3 tables, query table 1 results table 3	=?Utf-8?B?c2ltb24=?=	Microsoft Access Queries	2	5th Oct 2007 01:57 PM
Using the current open query or table to create new query	=?Utf-8?B?Y2hvb3NldG9sYXVnaA==?=	Microsoft Access Queries	0	31st Aug 2007 08:02 PM
Update query or create new table query or ??	=?Utf-8?B?SldDcm9zYnk=?=	Microsoft Access Queries	4	18th Jul 2006 05:13 PM
To have month and year as part of the table name in CREATE TABLE or MAKE TABLE Query	ichew@scs.com.sg	Microsoft Access Getting Started	1	18th Apr 2006 06:38 AM
Create Table Primary Key after Make Table Query And Update Table	=?Utf-8?B?Uk5VU1pAT0tEUFM=?=	Microsoft Access Queries	1	3rd May 2005 08:07 PM