admin
05-30-2003, 07:58 AM
Creating a New Table in Sequel Server.
<%
SQL = "CREATE TABLE tblName (Name char(50), Email char(50))"
dim objConn, strConnect
strConnect = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("/database/Database.mdb")
set objConn = Server.Createobject("ADODB.Connection")
objConn.open strConnect
objConn.Execute SQL
Set objConn = Nothing
%>
This will create a new table with the following fields:
Name, of type char, length of 50
Email, of type char, length of 50
By Mark W.
<%
SQL = "CREATE TABLE tblName (Name char(50), Email char(50))"
dim objConn, strConnect
strConnect = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("/database/Database.mdb")
set objConn = Server.Createobject("ADODB.Connection")
objConn.open strConnect
objConn.Execute SQL
Set objConn = Nothing
%>
This will create a new table with the following fields:
Name, of type char, length of 50
Email, of type char, length of 50
By Mark W.