Good morning
I have a large spreadsheet containing data that is taking ages to load.
Would it be possible to store this data in Access and then lookup into Excel? I have created a sample and can pull the data into Excel in another sheet, but cannot see how I can lookup. Basically I am essentially trying to do a VLOOKUP or XLOOKUP from one field in Excel and pull the data from Access into a new cell
Thanks in advance
Bookmarks