Looking for some advice. I am currently trying to come up with a solution to automate files that are manually being sent in the form of an excel files. Currently we are requesting users to send us files via email and upon receiving the excel files I need to manually reformat the files before inserting them into our SQL DB to manually update our records with fresh data. (Am using Microsoft SQL Server Management Studio) I know the external applications are sending their files to their backend in the form of an EDI batch job. How can I automate this entire process? Any advice would be appreciated.
0 Answers
Related