MS Access Code

Hi, I have a small task, I need someone macro or vb code which or any other solution that does the job. I have my MS Access database linked to an excel spread sheet and I need to query the spread sheet and insert the results into a MySql database table that the Access database is linked with. If you look at the attached images you can see what I need. The [login to view URL] image is a screen shot of the query I put together which is linked to the excel spreadsheet and the [login to view URL] is the actual MySql table that I have Access linked to. The MySql table has all the fields that are contained within the Access query but all items are contained within 1 record/row (order_id, active, sold, pending etc..) but the query returns 3 records. I need to place the data from the 3 rows Access query into the single row of the MySQl table using the ordered field as the criteria. Note that the Access query has a field named Status which returns Active, Pending and Sold values in the column, the field to the right of Status is named Total, I need to insert the values from the Total field into the MySql table in their corresponding fields (active, sold and pending) I will also need to insert the Sold record from the Status Access query AvgOfSelling Price field into the MySql median field and the % Change field for the same record inserted into the MySql table %_change field. I can supply you with the spread sheet an database when you need it. My maximum budget is $50 USD. Thank you for your interest!