boolean field in create table query

[snehal G]

hello
i am writing a query to create table which contains boolean fields
i tried following code but getting syntax error.

con.execute "create table exa (boolean paper('TRUE','FALSE'),boolean TW('TRUE','FALSE'))"
can anybody help me to solve the prob
thanks

[Cimperiali]

if it is access:

Option Explicit
Const dbPathName As String = "Data Source=D:\Cimperiali\Vb\Office\Access\ImportFile\db1.mdb"
Private Sub Command1_Click()
    Dim strSql As String
    strSql = "Create table abc (paper yesno, Twa yesno)"
    Dim cnn As ADODB.Connection
    Set cnn = New ADODB.Connection
    cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & dbPathName
    cnn.Open
    cnn.Execute strSql
    cnn.Close
    Set cnn = Nothing
End Sub