creating a tempoary table

Hi
Has anyone got an example of creating a tempoary table in access db using asp coding?
or can anyone tell me how it is done please.
cheers
Hesh

Try this
select * into #temp3 from mytable

or try these functions to convert to xml.
I use these functions to save a temporary table on my
hard drive so that I do not have to query a second time
every time the page is refreshed I just look for a file that exists and display that instead. ( home made cache )

Bob@lyrex.com


Public Function ADORecordsetToXML(rs)
Dim s

ADORecordsetToXML = ""

If rs.Count > 0 Then
Set s = Server.CreateObject("ADODB.Stream")
rs.Save s, adPersistXML
ADORecordsetToXML = s.ReadText()
End If
End Function

Public Function RecordsetToXML(rs)
Dim s

RecordsetToXML = ""

If rs.RecordCount > 0 Then
Set s = Server.CreateObject("ADODB.Stream")
rs.Save s, adPersistXML
RecordsetToXML = s.ReadText()
End If
End Function

Public Function XMLToRecordset(strXML)
Dim s

Set XMLToRecordset = Nothing

If strXML <> "" Then
Set s = Server.CreateObject("ADODB.Stream")
s.Open
s.WriteText strXML
s.Position = 0

Set XMLToRecordset = Server.CreateObject("ADODB.Recordset")

On Error Resume Next
XMLToRecordset.Open s

If Err.number <> 0 Then
Set XMLToRecordset = Nothing
Exit Function
End If

XMLToRecordset.MoveFirst

If Err.number <> 0 Then
Set XMLToRecordset = Nothing
Exit Function
End If
End If
End Function