excel and access integration
Posted by Bruce Mencer on August 11, 2001 5:01 PM
Here is my problem and I searched the whole board and could not find an answer.
I have set up a data base in access of contacts listing various fields as contact, company etc.
I have excel spreadsheets with product info and pricing.
I have excel spreadsheets that I use for quotes.
Is there a way to set up the quote forms and have different cells pull info from either the pricing spreadsheets or the customer info fields in access?
I am using Office 97.
I always thought I was pretty computer literate until I found this board :-)
If it's real detailed, please email to me at firstname.lastname@example.org