Excel / Access Question

L

Les Stout

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation of records on spreadsheet 2
Excel to Access - User needs Access installed? 1
Excel - Access Integration 2
Excel macro in Access module 7
Programming question 5
insert excel to access 2
Passing data to an event handler 3
Sharing variables between the macros in 2 open excel workbooks. 1

Top