Create SQL Table Syntax

[dowlingm815]

Hi,

I am having a syntax error creating a table. The table is defined with space and special characters, are these allowed when defining a table. thank you in advance for your guidance.

mary

the code is as follows:

CurrentDb.Execute ("CREATE TABLE tbl_IDT([Sales Order Id] Integer, " & _
                                        "[Sales Order No] Integer, " & _
                                        "Fund VARCHAR(6), " & _
                                        "Org VARCHAR(6), " & _
                                        "[Sales Order Date/Time Created] DateTime, " & _
                                        "[Buyer: First Name] VARCHAR(25), " & _
                                        "Quantity as integer, " & _
                                        "[Unit Price] money, " & _
                                        "[Extended Price] money, " & _
                                        "[SKU/Catalog #] VARCHAR(25), " & _
                                        "[Product Description] VARCHAR(50),  " & _
                                        "[Account Code] VARCHAR(6))")
 

[dowlingm815]

the answer is yes, my code was error-ing due to the "As" clause that i wasn't seeing.

[NeoPa]

Right on the button Mary. Line #7 is your culprit. The AS SQL keyword creates an alias, rather than defining a field type.