I have:
tblSites
SiteID .. .. SiteLocationID
tblLocations
LocationID .. Town .. County
I have an Excel document with ~700 sites on, but lists towns / counties, whereas I need a LocationID to put into my site. Is there any way to automatically pull the LocationID from my list of locations for each record in either Excel/Access? Or will I have to manually do this...