View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Stout[_2_] Les Stout[_2_] is offline
external usenet poster
 
Posts: 396
Default Excel / Access Question

Good day all, i have a central database that our whole department uses
and i have a list of part number responsibility in it, which the users
update as and when required, my question is that i need to use the
latest list for a macro in excel, is it better to :-

a. Import external data, or
b. Do a look up from excel to the access table for the name and e-mail
address of the responsible buyer ?


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***