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

Recommended Answers

All 3 Replies

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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.