Hi,
I am working on an PowerApps applicaiton, my requirement is app should have feature to read excel file uploaded by user and insert the data into SQL table.
As a first step I am uploading excel file to sharepoint and in next step want to read file content and insert in SQL table.
The challenge is excel file I receive from external source doesn't have any tables defined. I could not find any way to directly get rows from excel without reading table.
Please suggest how can I read rows in excel where tables are not defined and insert into SQL table. Also suggest if there is any other approach to achieve my goal.
Thanks,
Sujanakar Reddy