I am working with data in both Excel and Access on a regular basis. I often need to do a quick lookup (i.e., essentially a Vlookup) in Excel, but the table that I am pulling from is in Access.

Is there a most efficient way that you would recommend to do this? I should probably note that when I am constantly pulling from one of three or four of the same tables in access (though the spreadsheet in Excel that I am pulling from is often just a random sheet that I happen to be working in).

One option is to import the Excel file into Access, and then to perform a query in Access the accomplishes the lookup, and then to export the results back out to Excel. This is a lot of steps and I am hoping there is a simpler, somewhat more efficient way to do this.

Thanks for any suggestions!