Apr-26-2021, 07:22 PM
Hi Experts,
Have requirement as below. Our clients are going to place multiple files(.xls,.csv, .txt,etc..) in one share drive. Our Python script need to pick those files and load that data to our Oracle Table. For this process have created Python script. My script is only working for picking .xls and convert into .csv and load it into table. But this script is not working for Multiple file capturing and converting all files to .csv and load the data to table.
Please suggest how can we implement a code to satisfy the above process.
Thanks
Amy.
Have requirement as below. Our clients are going to place multiple files(.xls,.csv, .txt,etc..) in one share drive. Our Python script need to pick those files and load that data to our Oracle Table. For this process have created Python script. My script is only working for picking .xls and convert into .csv and load it into table. But this script is not working for Multiple file capturing and converting all files to .csv and load the data to table.
Please suggest how can we implement a code to satisfy the above process.
Thanks
Amy.