Wednesday, May 07, 2008

Refreshing an imported table in Microsoft Access

Another fun problem I ran into recently and couldn't find an answer to using Google: You have a table that you've imported, and you want to refresh the contents of that table. The main problem is that if you simply delete the table and then re-import, you will lose all of the information about that table in your queries. If it's a complex query, then that could be problematic. Here's the solution.

1. Import the table with the new data into your Access database.

2. Once you've imported the table, rename the table to the same name of the table that you want to replace.

3. Access will now prompt you whether you want to replace the existing table. Answer yes, and voila, table refreshed!

Yes, it's a simple solution but it wasn't very obvious, at least for me.

No comments: