Populate Drop down box with Access database

Hi,
I am trying to build a simple excel spreadsheet for purchase orders. I want to get data for suppliers, job sites, and their addresses out of a simple access database. How do I get this started? I'm sure someone has asked this before.

The intent is to make filling the PO out simpler and populate some cells with that data. I've been monkeying with the Excel 2007 data, but, it doesn't seem to cooperate. Am VERY familiar with VBA, and writing data to Access, but, can't seem to get going on sucking the data from access (the end solution will go both ways, with the same database).

I probably want to have one drop down for the supplier name and fill in the address, phone number and contact cells too.
Thanks in advance.
(sorry, its monday)

The best advice I have for you if you are skilled in vb is to look at the Northwind Sample Database. There are lots of great examples in there.

Hope this helps,

Dan

Northwind is Access, I want to populate an excel spreadsheet with the access data. I will go look and be back shortly. Thanks

Yes, I know we can do it in Access. Here is what I am up against.
My present employer uses Excel for everything. We have no databases in use for our product, which is factories. Yes, we build complete factories. So, each is very different, although our factories do build a common product. Our data is, well, confused as people record their data in non standard form.

I have a method of drawing data from Excel and dumping to Access to hold the data, the problem now is that I need to get them to put "todays date" in the same cell each time. Then we can find all the spreadsheets created "Purchase orders" on the new form, and extract the data for use in the future.

The boss then asked, if you can do that, can you create a drop down to fill in the ship to addresses, and the supplier information. I said yes, but, that would take a little work.

The organization does need to grow up with their use of software. I've tried to purchase any of the many packages available, but they won't do that, as the accounting department wants to remain separate and the expenditure cannot be justified from my level. I am an estimator, just trying to improve our data collection. My request to populate directly from access is just a first step, and someday they will come around. But, not today.

I need help with just this simple request for now. Even though we all have access, they are quite afraid of it... for now. Baby steps