99% using Excel as Datasource...

im reading excel as a data source, and everything seems to be fine except this damm error that im getting... can anyone please tell me whats wrong??

thanks.

the error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6dc Thread 0x78c DBC 0x1649024 Excel'.

my code:

'## The Data to extract
<% szSQL = "select * from Events"%>
'## Create and open the connection
<% Conn.ConnectionString = "DBQ=" & XLFile & ";DRIVER=Microsoft Excel Driver (*.xls);UID=admin"
Conn.Open%>

'## set the cursor to be static.
<%rs.cursortype = 3 ' adStatic.%>
'## open the recordset
<% rs.open szSQL, conn%>

'## Disconnect recordset, eliminate connection
<% rs.activeconnection = nothing
Conn.Close
Set Conn=nothing%>

'## iterate through the recordset.
<%while not rs.eof
response.write RS("ParentID") & " -- "
response.write RS("Configitem") & " -- "
response.write RS("Department") & " -- "
rs.movenext
wend


thanks.

Try closing your connection after doing the while loop. That may work.

Good luck,

Tim