Access Expert 20 shows importing from excel, you could use that to import bulk products into your tables. If you're just looking for product codes you can just only import that field.

Thanks for the answer, but import a list from excel to a table is not what I meant. Richard taught us to add product 1 by 1 from productcombo using add btn. Is there a way allows you to c&p all the productcode from customer order form into code field, follow with quantity, and the final order will be generated? looking forward to hearing from you. thx

Ah, that's quite a bit different. Do you have to make them in excel and then move to access after? It would be a lot simpler if you could just make them in access.

I don't really have any experience doing what you're trying to do beyond setting up access with the beginning data and then using access from then on. However, if you're going to be doing this long term and frequently, transferring over every order from excel into access, it looks like something that DoCmd.TransferSpreadsheet could do. Maybe start there.

Qun Yu -
I think you have skipped a step somehow.  The Products in your Excel would be imported into your ***  ProductT *** table.

The OrderDetailF subform you have highlighted in the screen capture is "filled in" or added to the OrderDetailT for each item sold FOR THAT ORDER by the combobox next to the ADD button.  It is basically a lookup of the products you have FROM the ProductT table.

I suggest you re-watch the Developer 23 videos at least starting at Lesson #3.
And yes - you can import your data from the Excel to Access very easily.  Either with a copy and paste (if the fields match exactly between Access and Excel) or through an append query.  Adam gave you some lessons but also search above for "append query" if you need additional resources.

This TechHelp Video should also give you some help:

Import New and Changed Records
https://599cd.com/blog/display-article.asp?ID=1459

If I understand you correctly, you're getting an order from the customer and it's a spreadsheet containing a column of product numbers that he wants to buy. You want to copy and paste that into Access and have it fill in the details in your order form. Correct? If that's the case then yes, Scott has the right idea. You want Access Developer 23.  It's a concept similar to what I do with the rental inventory where you can bulk-scan in a bunch of returned books. You'll just need to copy the list of products from the Excel sheet, paste them into a form in Access, parse the items, DLookup the product details, and use a recordset (or SQL INSERT) them individually into the order.