I know excel vba ok not much ado. I know C# and VB.net for windows & asp.net and sql server TSQL.

I get a daily email from the bank and need to take the data from the attachment and insert into sql server.

I could do a web page where i select from the excel file once the file is saved on the web server then use ado.net to fire the stored procedures. But my boss wants the email to go to a specific unmaned account and have vba to save the file some where and then try a folder watcher type thing to take new files and read the data into sql server. Any recomendations or ideas?

Thanks~