I'm currently on a similar project.
I get external data from MS Acess to update the Excel table.
From: David Cristallo [mailto:[log in to unmask]]
Sent: 20 March 2001 17:25
To: [log in to unmask]
Subject: 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 countries
and their associated abbreviation and ISO code. From Excel, I would like to
retrieve, for a given country abbreviation, the corresponding ISO code. Is
it possible to retrieve this information without using a recordset to store
the returned ISO code ?
Access 97 & Excel 97 under NT4
Excel 2000 & Access 2000 under NT5