Excel to Access lookup similar

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


Also raised in
https://www.mrexcel.com/forum/micros...ml#post4832381

Truthfully, the easiest way is to create a query in Access.

Assume your zip code field is called Zip in a table called MyTable. Your Longitude and Latitude fields are called Longitude and Latitude and are in the same table.

A Query would look like this:

Please Login or Register  to view this content.

In your query, you would enter the zip code when the parameter requests it.

crossposted: https://www.mrexcel.com/forum/micros...ml#post4832381

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).