I manage to automate download periodically to a specific folder called "datafolder" and now I try to automate import the newest file in "datafolder" into Toad for Oracle. I used:
list_of_files = glob.glob('C:\Users\USER\Desktop\belajar\ProjectDAS\downloaded_files\*csv') newest_file = max(list_of_files, key=os.path.getctime, default=None)
To get the newest file and I already make the table in oracle, but still can't automate the importation periodically. The newest file contains the data of the beginning period to the latest