a really exotic Excel and Acces combination

[airtabaki]

I have a database where all the info of my suppliers is stored. In our company we use special excel sheets to order some stuff. Till now we allways have to write down the adress of the suppliers on the excel sheet each time we want to order something.
I want to optimise this system in Acces. But the things we order are so different that it would cost us to much time to create a database were all the possible products are stored. So I want to create an acces report/or form or something where the adress and info of the supplier and the number of the order form is in acces, and the ordering products information is in excel.
Is this possible?

 

[dhookom]

You can use code in either Excel or Access to read information from one to the other.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.