-
Best way to handle inserting data from excel attachment to SQL Server database?
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~
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules