The INSERT INTO statement contains the following unknown field name (1 Viewer)

[trab]

I have a linked table, and i've created a local table by copying (structure) only.

When I come to append records from the linked table that satisfy a given date range, I get the INSERT INTO error message.

Any thoughts?

 

[theDBguy]

Hi. Can you post the SQL statement and the actual error message (screenshot)?

 

[The_Doc_Man]

Invariably, this error tells you that the field you named does not exist in the place you said (or implied) that it does.

Check for spelling first. Check for having odd syntax like quoting characters where they don't belong. When you copied the linked table to the local table, you created duplicate field names. So if you didn't properly qualify the fields with their table names, Access might be confused as to where you want to put things.

 

[Guus2005]

Yes, i have a few thoughts.
- the linked table is in fact an excel spreadsheet and therefor is read-only
- you are inserting the same record twice.
- use don't use # to specify dates
- the dates are in a wrong format mm/dd/yyyy or yyyy/dd/mm or any other wrong notation
- you don't have write permission
- you are using ` where you should be using '
- your query is using a join where you are trying to match a string to a boolean field
-

I could go on but i don't want to. In short, there isn't enough data to answer your question and perhaps the answer is already there. Can't tell.