Select * not copying all records

[EckyThump]

I have two tables one of which is a holding table for the other.

I am using the code:

strsql= "DELETE * from Tablename
DoCmd.RunSQL
strsql = " INSERT INTO Tablename " _
& "SELECT * FROM HoldingTable"
DoCmd.RunSQL

The problem is the two tables are different once the Tablename populated from the holding table.
Any clues as to why?

 

[randy700]

the two tables are different once the Tablename populated from the holding table
Different in what way?
Have you verified that the first (DELETE) query worked?
How about...

strsql= "DELETE * from Tablename [COLOR=red][b]"[/b][/color]
DoCmd.RunSQL [COLOR=red][b]strsql[/b][/color]
strsql = " INSERT INTO Tablename " _
& "SELECT * FROM HoldingTable"
DoCmd.RunSQL [COLOR=red][b]strsql[/b][/color]

Randy

 

[EckyThump]

Thanks for the reply.
I have found the problem.
One of the tables had a slightly different structure.
I have now fixed this and all now seems to work.