Create Table

[aziz rasul]

The following doesn't work. Can anyone help?

Sub MakeTableWithSQL()

Dim strSQL As String

strSQL = "CREATE TABLE tblImport (ID AUTONUMBER, First_Name TEXT, Last_Name TEXT);"

DoCmd.RunSQL strSQL

End Sub

 

[MHM]

Hi rasul,

change to:
... (ID Autoincrement, ...

Mic

 

[aziz rasul]

Thanks Mic. That worked.