VBA Access problem with RunSQL

[manontheedge]

I'm trying to copy part of one table into another (using a VBA macro), and I keep getting the error message

'3127' INSERT INTO contains the following unkown field...

...the reason I'm confused is that the field names are IDENTICAL. Plus, I've used this code for a few months and never had a problem, until I tried to add what I have to a different database ( but both databases have the EXACT same field names )

if anyone can help I would appreciate it.

this is the code...don't know whether or not it will help...

 
objAccess.DoCmd.RunSQL "INSERT INTO Y    SELECT *   FROM X;"
objAccess.DoCmd.RunSQL "DROP TABLE X;"
 
 

[Rabbit]

Well, what are the unknown fields?

[MMcCarthy]

I'm trying to copy part of one table into another (using a VBA macro), and I keep getting the error message

'3127' INSERT INTO contains the following unkown field...

...the reason I'm confused is that the field names are IDENTICAL. Plus, I've used this code for a few months and never had a problem, until I tried to add what I have to a different database ( but both databases have the EXACT same field names )

if anyone can help I would appreciate it.

this is the code...don't know whether or not it will help...

 
objAccess.DoCmd.RunSQL "INSERT INTO Y    SELECT *   FROM X;"
objAccess.DoCmd.RunSQL "DROP TABLE X;"
 
 

There are two ways to do an insert statement ...

 INSERT INTO [tableA] ([column1], [column2], [column3])
VALUES ('value1', #value2#, value3);

OR

INSERT INTO [tableA] ([column1], [column2], [column3])
SELECT [column1], [column2], [column3] FROM TableB;

[NeoPa]

The point here being that your SQL was not of the right syntax.