write session variables to access database

I have a load of info that a user has entered, it is in the form of session variables. Can anyone point me in the direction of how I can write that information back to an accesss database?

thanks

Em I think you would have to extract the data from the MySQL database into a csv format using a tool like MySQL query browser :)

I don't want to retrieve the info, I want to write it to the database

As far as I am aware php can't write to a microsoft product directly. You'd need ASP to do that perhaps

sorry dude...but this is the ASP forum and I mentioned in my first post about writing TO a databse...it seems like you are answering someone elses question.

I am using ASP and not PHP....thanks for the effort though

now that wasn't very clever of me was it :(

What are you having trouble with, exactly? Connecting to a database? Using session variables? You just need to construct a SQL statement, open a connection and execute the statement:

strSQL = "INSERT INTO table (field) VALUES ('" & session("mySessionKey") & "')"
set oCn = server.createObject("ADODB.Connection")
oCn.Open(myConnectionString (http://www.connectionstrings.com/))
oCn.Execute strSQL
oCn.Close
set oCn = nothing

Spud, it sounds like his biggest issue is figuring out how to parse the session string into its individual parts so it can be inserted into the database.