B
Brad
I ran into something strange while doing a Make Table Query that was followed
by an Append Query (from a “purchased system†table that has many field names
with embedded blanks.)
To understand this issue better, here is what I did to recreate the problem.
Created a new table with only one field named “Cust Name†(note the embedded
space in the field name)
Used an Access “Make Table†query – this worked nicely.
Then I tried an Access “Append Queryâ€. Access generated this field name in
the Append To: field [Cust Name] (Note the brackets that Access
inserted)
When I run it, I receive the following error msg.
“The INSERT INTO statement contains the following unknown field name: ‘[Cust
Name]â€. Make sure you have typed the name correctly, and try the operation
againâ€
I can resolve this by removing the brackets.
This is not a big deal for this little test, but the original production
table has many fields with embedded spaces in the field names. It would be
nice if I could somehow ask Access to not wrapper these field names with
brackets when doing an Append Query.
Is this a feature? Am I missing something obvious?
Thanks,
Brad
by an Append Query (from a “purchased system†table that has many field names
with embedded blanks.)
To understand this issue better, here is what I did to recreate the problem.
Created a new table with only one field named “Cust Name†(note the embedded
space in the field name)
Used an Access “Make Table†query – this worked nicely.
Then I tried an Access “Append Queryâ€. Access generated this field name in
the Append To: field [Cust Name] (Note the brackets that Access
inserted)
When I run it, I receive the following error msg.
“The INSERT INTO statement contains the following unknown field name: ‘[Cust
Name]â€. Make sure you have typed the name correctly, and try the operation
againâ€
I can resolve this by removing the brackets.
This is not a big deal for this little test, but the original production
table has many fields with embedded spaces in the field names. It would be
nice if I could somehow ask Access to not wrapper these field names with
brackets when doing an Append Query.
Is this a feature? Am I missing something obvious?
Thanks,
Brad