Re: Inserting data based on email attachment

On Mon, 30 Apr 2007 02:47:50 -0700, sandeep wrote:

> Hi everyone,
>
> I have a requirement where in I have to detect an incoming mail,
> download the attachment which is a flat file containing some data, then
> i have to insert in to oracle tables. I just want to find out whether
> identifying an incoming mail and downloading the attachment can be done
> using a windows batch program, so that i can convert the flat file to
> oracle rows. Please correct me if my approach is wrong, and any sites
> for the sample windows batch programs would be great.
>
> Thanks
> - Sandeep

I've done things like that on Linux. A financial company was regularly sending a spreadsheet in Excel format (S & P 500 index) which had to be inserted into database upon receipt. I've set up a Linux box, with a Perl script activated from procmail. Perl script used Spreadsheet::ParseExcel to parse the incoming data and insert them into the database.

-- 
http://www.mladen-gogala.com