Error 3127 - Insert Into statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table linked to an Excel worksheet as a means of importing data from
the excel file. I need to append all data from the "imported" table to
another table so updates/calculations to the new data can be performed.

The problem is that I get the 3127 error. All fields have the same names
and are of the same data types. I've gone so far as using a Make Table
querry (based on the "importing" table) to generate another table that would
be compatable to the "importing" table (I'm dizzy now). To no avail, I
continue to get the error.
 
Error 3127 implies something's incorrect with a field name in your query.

What's the SQL look like for it?
 
Back
Top