access 2013 vba - create new table with autonumber field and set as primary key

[RCBricker]

ok so I have set up a Boolean function to see if a table exists before importing data. Now I want to create the table if it doesn't exist. I only need one field with that field being both an autonumber field and the primary key.

Any ideas?

I was looking at the create table but can not figure out how to write the autonumber attribute to the command.

I was thinking along the lines of:

dbF.Execute "CREATE TABLE strTBLPname " _ 
        & "(REC_NUM CHAR CONSTRAINT MyFieldConstraint " _ 
        & "PRIMARY KEY);"

but not sure what to replace the CHAR with to get it to be an autonumber.

 

[RCBricker]

Nevermind figured it out.

For anyone looking to for the answer

    strADDtbl = "CREATE TABLE [" & strTBLPname & "]([REC_NUM] " _
        & "AUTOINCREMENT PRIMARY KEY)"
 
    DoCmd.RunSQL strADDtbl, False
    DoEvents
    Application.RefreshDatabaseWindow