Forum Discussion
Kamana08
Feb 16, 2023Copper Contributor
How to copy record from Shared Excel file to table and its sub-table at one button click?
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.