In general you select the fields i Access with suitable conditions. You
could do that in VBA with a selectstatement or graphically with
MS-Query which you have in Excel, if you installed that option.
Hope this helps.
Från: [log in to unmask]
[mailto:[log in to unmask]]
Skickat: den 20 mars 2001 18:25
Till: [log in to unmask]
Ämne: Querying Access db from Excel
I know this is not really an Excel subject but don't crucify me...
Let's say, I've got one access table, tblCountries, with a list of
and their associated abbreviation and ISO code. From Excel, I would
retrieve, for a given country abbreviation, the corresponding ISO code.
it possible to retrieve this information without using a recordset to
the returned ISO code ?
Access 97 & Excel 97 under NT4
Excel 2000 & Access 2000 under NT5