asp :create a access table within the asp code

[neelawathura]

Can some one help me in creating a MS access table within the asp code itself.

 

[FesterSXS]

Try this...

<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(YourDBConnectionString)

strCreateSQL = "CREATE TABLE myTable (myField1 int, myField2 varchar, myField3 varchar, myField4 bit)"

objConn.Execute(strCreateSQL)

Set objConn = Nothing
%>

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com

 

[neelawathura]

Hey FesterSXS It Worked.Thanks

May i ask another question .How to retrieve the field names from that table.

 

[FesterSXS]

Not tried that before but maybe something like this...

<%
strSQL = "SELECT TOP 1 FROM myTable;"

Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, YourDBConnectionString

If NOT objRS.EOF Then
  For Each item in objRS.Fields
    Response.Write item & "<BR>"
  Next
End If

Set objRS = Nothing
%>

Of course - you could always store the field names into variables before you create the table. Then you can use these stored field names when it comes to extracting information.

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com