I just came across a real tricky question and am really stumped.
I'm wondering if there is a way either custom built or in an app in the app exchange to receive an email with csv attachment and import the data from the the file directly in salesforce.
The scenario is that a file gets emailed from a third party system daily with a csv file with approx 1500 records.
I need a way to have salesforce receive the email parse the csv file and import the content to a custom object.
I have seen an app that allows you to receive emails but doesn't do much more than that.
Any suggestions would be appreciated.