Create a temporary table.. Please help (1 Viewer)

[gdanalakshmi]

How do I create a new temporary table from a parameter query?

 

[RobertQ]

Hi,

if you create a query you can decide what type of query you want. One of the types is "tablecreatequery" (sorry, might be titled with other words in an english Access version).
Selecting this type of query you will be asked to put in a name for the query.
If you do so, the query will create a new table.

Remark:
If have seen your other posts. If you need the export for several times in the same manner you should not use a temporary table, but create one and use an add query type.

Kind regards

 

[neileg]

What is a temporary table? Do you want to create a table every time, and then delete it? Or do you want to hold a permanent table and change the data in it?

As RobertQ suggests, you can use a make table query to create a new table. You can use an append query to add data to an existing table.

As far as I know, there is no such thing as a temporary table in Access. Their temporary status is due to them being created and deleted. While they exist, they are exactly the same as any other table.

So, once you have used the table, you will have to explicitly delete it, or delete the data, depending on how you are handling it.