Create a table in an Access DB programatically (using ASP)

From:

CREATE TABLE IN ACCESS - ASP

Not sure what kind of columns BranchName and BranchCode need to be. I'll
assume Text(255) and Integer, respectively.

sTablename = Request.Querystring("name")

sSQL = "CREATE TABLE [" & sTablename & "] (BranchCode Int PRIMARY KEY,
BranchName Text(255));"

objADO.Execute sSQL