MySQL Forums
Forum List  »  Newbie

PLEASE HELP! - AUTO EXCEL FILE IMPORTING PROBLEM IN MySQL
Posted by: Daniel Tate
Date: April 13, 2023 06:55AM

Basically, I need to have MySQL import all excel files into MySQL that I put into a certain folder and need to update instantly or every few seconds or so. Not just import, but after it imports that excel file correctly, it needs to turn that file into a database with tables corresponding to the excel file. I believe that I already know that the excel file needs to be saved a certain way and then it will be compatible with MySQL without the need for an external software but I still need help with the mechanism where MySQL scans the files in that folder, copies any new files into MySQL and transfer it into a database with tables, thank you. PLEASE HELP!!!!

Options: ReplyQuote


Subject
Written By
Posted
PLEASE HELP! - AUTO EXCEL FILE IMPORTING PROBLEM IN MySQL
April 13, 2023 06:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.