I am importing an Excel spreadsheet into a table (table B). Then, I am using an append query to add the data in table B to my old table (table A). I have a form with a "show all records" button. The button event performs a SQL statement to select all records in table A and display the results in a listbox. The problem is, after running the import routine the query does not return the newly added records. I can open table A and see the new records. I save and exit and they are still there, but they still do not show up in the query result. To get them to appear, I have to copy them, delete them, and then paste them back into the table. Can someone please explain this to me? Is there a way to fix this? I am using Access 97. Thanks in advance for any help.