Temp tables in query

[citychap26]

Hi All

I was wondering can you create a temp table in Access like you can in Sybase for instance.

Select * from TableA into #tmpTable

Cheers

Sunil

 

[PHV]

In Access, you can use CREATE TEMPORARY TABLE instruction and then INSERT INTO.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[citychap26]

Hi

Thanks for the answer, please can you give me some example SQL.

Cheers

Sunil

 

[PHV]

Browse your computer local drives for files named JET*.CHM

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244