Hoping someone can help me, an area totally new to me. How does one achieve a lookup type function from an Excel field to an Access record (linked table).
Looks like i might be able to do this with MS Query, but despite trying to follow some online articles i've drawn a blank - way beyond me.
Within my Excel file i have a column called "PostCode", repeating down for 10,000 rows each and every month
My Access table (just shy of 1.7 million records so too big for Excel), has each postcode in one field, with its corresponding "Latitude" and "Longitude" fields.
I want to "lookup" the postcode (from within excel, looking within Access) and return the Latitude and Longitude coordinate into two columns within the same original Excel Worksheet.
A little experience with Access queries (not too much and many moons ago), but having looked at Query / Power Query didn't know where to even start !!!
Thanks in advance folks, i know some of you guys will be able to do this in your sleep
Looks like i might be able to do this with MS Query, but despite trying to follow some online articles i've drawn a blank - way beyond me.
Within my Excel file i have a column called "PostCode", repeating down for 10,000 rows each and every month
My Access table (just shy of 1.7 million records so too big for Excel), has each postcode in one field, with its corresponding "Latitude" and "Longitude" fields.
I want to "lookup" the postcode (from within excel, looking within Access) and return the Latitude and Longitude coordinate into two columns within the same original Excel Worksheet.
A little experience with Access queries (not too much and many moons ago), but having looked at Query / Power Query didn't know where to even start !!!
Thanks in advance folks, i know some of you guys will be able to do this in your sleep
