Append query unknown field name error, views but doesn't run...

[Accessor]

Hi all. I'm trying to fix an append query that generates the right recordset
just fine, but on run I get the error: "The INSERT INTO statement contains
the following unkown field name: '[CompanyDescription]'. Make sure you have
typed the name correctly, and try the operation again." I got this error with
that field under a different name (same name both tables.) Here's the sql:

INSERT INTO tblSymbolsMain ( Symbol, [CompanyDescription], [Security Type] )
SELECT qryNewSymbolsToAddToMainSymbols.Symbol,
qryNewSymbolsToAddToMainSymbols.CompanyDescription,
qryNewSymbolsToAddToMainSymbols.[Security Type]
FROM qryNewSymbolsToAddToMainSymbols;

So the field names match in both tables, the source is a find unmatched
query, and all field types are text.

Any ideas?? Thanks in advance...

Kevin

 

[Jerry Whittle]

I would check very carefully to see if it's [CompanyDescription] or [Company
Description] (with a space) in both tables. Usually you don't automatically
get the [] brackets unless there's a space. Both must match exactly or use an
alias.

 

[Accessor]

Hi Jerry, they're the same, just as I pasted it in. I got the error with a
different field name(s), in which there was a space. I removed it, but the
error persists.

I would check very carefully to see if it's [CompanyDescription] or [Company
Description] (with a space) in both tables. Usually you don't automatically
get the [] brackets unless there's a space. Both must match exactly or use an
alias.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi all. I'm trying to fix an append query that generates the right recordset
just fine, but on run I get the error: "The INSERT INTO statement contains
the following unkown field name: '[CompanyDescription]'. Make sure you have
typed the name correctly, and try the operation again." I got this error with
that field under a different name (same name both tables.) Here's the sql:

INSERT INTO tblSymbolsMain ( Symbol, [CompanyDescription], [Security Type] )
SELECT qryNewSymbolsToAddToMainSymbols.Symbol,
qryNewSymbolsToAddToMainSymbols.CompanyDescription,
qryNewSymbolsToAddToMainSymbols.[Security Type]
FROM qryNewSymbolsToAddToMainSymbols;

So the field names match in both tables, the source is a find unmatched
query, and all field types are text.

Any ideas?? Thanks in advance...

Kevin

 

[John W. Vinson]

Hi Jerry, they're the same, just as I pasted it in. I got the error with a
different field name(s), in which there was a space. I removed it, but the
error persists.

Removing the space changes the name. [Customer Name] and [CustomerName] and
[Customer_Name] are, to Access, three completely different and unrelated
fieldnames. They must match byte for byte, and a space is a character just
like any other character in this regard!

Are you certain that the fieldnames are in fact EXACTLY the same in the two
tables?

 

[Accessor]

I was just saying how they indeed are. I changed them yet again, and the
error persisted. I copied the table, renamed the fields again, rewrote the
query, and now it works. Thanks though... on to my next problem, running an
append query from excel vba...

Hi Jerry, they're the same, just as I pasted it in. I got the error with a
different field name(s), in which there was a space. I removed it, but the
error persists.

Removing the space changes the name. [Customer Name] and [CustomerName] and
[Customer_Name] are, to Access, three completely different and unrelated
fieldnames. They must match byte for byte, and a space is a character just
like any other character in this regard!

Are you certain that the fieldnames are in fact EXACTLY the same in the two
tables?