Appending Data From a Linked Table

[comp101]

I have an Excel sheet that changes daily with information on orders in process. I need to have an Access form that can be updated as to the status of each order so daily reports can be generated. Right now I have a table linked to the worksheet. What is the best way to show all of this information on a form and be able to have someone mark each order as it is goes through each of four steps. I would like to have a drop down list or button beside each order number. It needs to very simple so someone with no knowledge of computers can update it.

 

[PWise]

instead of creating a linked table create a query with this sql

SELECT Tablename.*
FROM [Excel 8.0;IMEX=0;DATABASE=c:\path\excellworkbookname.xls].[Worksheeetname$] AS Tablename

create a form on this query and you can edit the excell sheet directly

 

[comp101]

Sorry! I should have specified, the Excel sheet is receiving data from an ODBC source that I do not want updated.

 

[PWise]

so what do you want to update

 

[comp101]

I need a report that shows the "order #" and "customer name" from the excel file and then has steps filled in as they are completed. I only want this data to show up on an the Access report.