Create Table

Joined
May 15, 2006
Messages
1
Reaction score
0
I am using the following code in order to create a new table and then add some fields to the table, then I plan tao populate it with an append query.

I keep getting, an

"Run-time error '3290':

Syntax error in CREATE TABLE statement."

message. When I click on the "Debug" button, it highlights the " db.Execute strSQL" line. This procedure was followed straight out of an Access 2000 book. Can anyone tell me what I need to do to get it to work?

Thank you in advance for your help!
Glen

Dim db As Database
Set db = CurrentDb
Dim strSQL As String
strSQL = "CREATE TABLE tbl_Addl_Info "
strSQL = strSQL & "(Ref_ID text(255), Addl_Acct_Nos text(255)," _
& " Addl_PIDs text(255), Addl_Legals text(255)," _
& " Addl_ECUs text(255), Addl_TADMaps text(255);"
db.Execute strSQL
RefreshDatabaseWindow
 
Back
Top