What i need help on is as follows
I have 2 tables.
2. backup of live
I run a query that downloads a csv file and stores it locally on the server. Before the latest information is copied into the live table i run a query to delete the records of the backup.
Once the backup is complete another query deletes the live records before the update happens from the csv file.
What i want to do is before the live table is deleted to do a check that the copy from live to backup was succesful. I do not use a primary key.
The data in the csv file is exported from a Telecoms switch, hence to ensure that both tables match It would be easier to validate with the number of rows in both tables.
I am very new to access. created my first database, but want to do a check between the two tables
would apperciate some help