How to copy record from Shared Excel file to table and its sub-table at one button click?

Copper Contributor

Hello all, 

I have one Shared excel file with project Num, Part no. and quantity. Now I want to export this data to two different access tables:

1. tbl_parts : This table contains OrderId , Part number and Qty

2. tbl_Orders: this table contains Project Number and OrderID

How can I read data from my excel file , so that my project name is copied to tbl_Orders and part number & quantity copied to tbl_parts with same OrderID on one button click?

This is my sample Excel file.



1 Reply


you can use Import wizard from within Access.Screenshot_2.png