Hi all,
I am working on a program that will take up Excel files, with columns in a certain order and with specific names, and load the data into a MySQL database table.
This I have already achieved.
My challenge is how to have an email address where the Excel files will be mailed and stored at a location where the program (which I have mentioned above), will pick them up and load the data.I am not sure how to achieve this though, whether by Java or what.
Please assist and I thank you in advance.