Help me Please

[ffejeff224]

Okay so here is what I want to do. I get these excel spreadsheets that are filled with fields that I don't care anything about so I would like access to query these excel spreadsheets for very specific fields that I define. The problem I run into is this. I currently have a macro that imports the excel file into access and runs a query and it works for one spreadsheet, but when I use a different file with additional or fewer fields it throws everything off. Every time I run the Macro I have to delete the table that access creates when it imports the excel table into access because it says that they have to have the same fields. Also, when I load a new spreatsheet in, the query that I have set up to pull the results messess up because the fields I defined were in the previous table.

So I guess what I'm asking is this. Can you write a query, or use some other tool, in access that allows you to search an entire table for specific field names and then pull those fields.

Thanks for your help!