Help with Access Database and Excel

[kent christensen]

TRP Model.zip
Quote_Example.zip
I was wondering if someone can do this for me or tell me how to do it. I have tried for a week to make this work and im not sure what to do next. I need to have the model complete by this friday and have had no luck. This is what i need.
Okay so i have an excel sheet and database that is attached. There are some fields in excel that i wish to be added to the database table "quotes". They are:
Company
Location
AM Phone
Am Name
Am Email
Customer contact name
customer email
customer phone
date


Then i want to take the SKU's in the excel sheet and the quantity and run them through the queries called "customer Quote". There are 6 different queries for 6 different currency exchanges. However, i do not have this set up but i was wondering if you can have a combo box set up on the TRP model form with the different currencies so that the correct query is ran. I would like to get the total credits for SKU's that were inputted and then output the values and total value back into the excel file where it is highlighted yellow. Then i would like the total value for the SKU's to be added to the "quotes" table in the correct credit field. I would like the other credit currencies to either have a blank or a zero.

So here is what i need to be short:
1. take the data in the excel file and have it uploaded into the "quotes" table.
2. Run the correcy query based on type of currency to get values of sku and a total value. Have the total value inputed into the "quotes" table and have the sku values inputed back into the excel file.
2a. Set up a combo box to have the correct query run based on currency selected.
3. Take the Total credit and Quote ID and input them into the excel file. I set up the Quote ID to be an autonumber.
4. have this whole process linked to a button on the TRP model form.

Please help me out. Im so lost here!
Thanks!

[jimatqsi]

I can't open your .accdb file, maybe it's because I am using Access 2003, I'm not sure.

Have you linked the excel sheet to the database. By that, I mean
File / Get External Data / Link and choose Excel file type

If you do that you can treat the Excel sheet as a data table for input; that will help you accomplish number 1 and 2 on the list.

Jim

[kent christensen]

JIm,
Thanks for the response.
Yes it is a 2007 access file. As for linking the excel sheet i just did that, however, alot of the data in the sheet isn't in a table format and is more of a from format and therefor doesn't really mathcu up as a table. I think i need to use VBA to input/output from certain cells. I just suck at using VBA.