import access data into excel cells?

[Guest]

i have an access database that has 5000+ entries. An example entry would be
Customer name, ship to name, ship to street, ship to state, ship to
additional info, invoice name, invoice street, invoice state, invoice
additional info.

I created a new form to write up orders in excel now i have 9 diffrent cells
in excel that i would like to place my database info into. I would like to
do a search for the customer name only and when i select the name it will
auto fill in the other 8 cells based of that line in the access database.

What i am realy looking for is a clear answer as to how i can do this or
even better a sample spreadsheet where this is being done or a website that
has such info clearly spelled out. I realize it will probably need to be
done in VBA and that is not too much of a problem but would be nice to have
an example to go by.

 

[Guest]

hi,
use micro soft query.
on the excel tool bar
goto data>get external data>new database query. follow the
wizard.
you may have to add your access database as a data sourse.
you can put a prompt in the query to ask for the cust name.