You'll have to ignore my ignorance as I am not very advanced with Access. I have a rather complicated Access Database and I would like to export some information from one of my tables in Access into an Excel spreadsheet.
Ideally, what I would like to do is have a drop down box in Excel where I could select make, model, serial number and the price would be inserted into the spreadsheet. The make, model, serial number and price are all located in the same table in my Access database. The only solution I have found so far is to create a program that will do this for me. As I said earlier, I am not an advanced user of Access and creating a program is a little over my head. Is there an easier way to do this?