Brackets in the Append To row of an Append Query

D

DDogCap

I have a table that I copy and then want to append the original table to it
giving a new table with doubles of everything.
I copy the table then, I create a query using query wizard. I choose all
fields in my table. Then name it and go to Modify. I change it to an append
table and choose the copied table mentioned above. At this point, all of the
fields listed on the "Append To:" row have brackets around them the Append
Query doesn't run correctly. I have to manually strip the brackets from this
row and then the query works fine. Thoughts?
 
D

DDogCap

The error I get is "The INSERT INTO statement contains the following unknown
field name: '[categoryid]'. Make sure you have typed the name correctly, and
try the operation again."

[categoryid] being the first field in the query.
 
D

DDogCap

Ahh yes, much cleaner. However my table name has two words, "Gas Inventory".
What's the proper syntax? I've tried Quotes and brackets but it can't find
the table.
-Galen
 
Top