Change the table reference - Help

[brunotamietto]

Hello,

I´m using the Macro in Access [SELECT INTO X VALUES Y] ( Where X is a table and Y is the data).
When I change the table X to X2 doesn´t works.

The data in the Table X is in the row 1042.
How can I change the table and keeping counting the data?

When I Put the old table again works perfectly, but when I put other table , doesn´t show a error mensage, just don´t send the information to new table.

Someone, know how change the table reference?

[JoeM]

Does table "X2" already exist?
If so, what are the fields and how are they defined?
And what does your actual query statement that is supposed to be inserting the data actually look like (can you post the real code)?