I have an Excel file that is updated regularly I.e. Every minute, and I have linked this file to a table in MS Access. This works great. However, I cannot index my key unique field, and therefore, I created a make table query to recreate the table. I can then index my unique field and then set up a relationship to my other tables, and build some queries.