Replace old data with new one whit out update or create table.

[cristi08]

Today is a long day !
I wish to replace the entire old data from a table with new one. Update is not helping me cause i do not have an autoincrement field. What to do?

Thank you in advance

[cristi08]

Today is a long day !
I wish to replace the entire old data from a table with new one. Update is not helping me cause i do not have an autoincrement field. What to do?

Thank you in advance

It was so simple, use delete queries and after use select and insert query.....amazing

[xylude]

Why not just add an autoincrement field? It should still let you do that if you don't already have one.

[cristi08]

It a N:M table, it a report with data from many table