Forum Discussion

Kamana08's avatar
Kamana08
Copper Contributor
Feb 16, 2023

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.

 

Resources