My client receives a .csv file from a supplier via email on a daily basis. I need to figure out a way to automate the upload of this .csv data to MS SQL Server as the email is received. I need a solution that runs server-side (Microsoft Exchange) which I believe rules out a VB Script running in Outlook which I know could otherwise do the job.
I'm very experience in working with MS Access and VBA but I'm not sure that that really helps here. A quick google has made me wonder if PowerShell is the answer, but I know nothing about it and could do with some guidance/examples.