I have created the append query in access and have my new data to append to the access table. I have 1500 rows but every time I go to append, it says its about to append 4881 rows. I have deleted the rows several times but it still keeps appending 4881 rows.
Could someone help? What could be the issue?