From my access application I'm trying to lookup values in an Excel file. I thought I could like the file and simply
do a Dlookup on the query I created on the linked Excel file but it doesn't seem to be able to search the proper
value. I can see the data from the first row , but not the value I searched on!
I'm assuming I either have to use Vlookup or something else to the query for it to work!
I'm also guessing that Excel doesn't present the data to access as an external database would!
There might even be a way to use VBA to access the excel file directly without linking but not sure how to do that!
The Excel file is about 1700 records an it changes regularily ( minutes)
I have no code to show other than using a typical Dlookup!
Dim xyz as string
string xyz = DLookup("[Sector]", "Cell_query", "[network] = '" & Me.network.Value & "'")