Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 SQL Mail updating via Attachment

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-17 : 08:02:48
Donnie Swafford writes "In doing a search I found an old article on your site about updating a database using SQL Mail and an attachment published on 9/15/2000. The article is very helpful but I need the final missing peice. If it exists on your site I have missed it in my search. I want to process attachements (Excel Sheets) sent to the SQL mailbox to update my database. Using the example in the article i can save the attachment but how do I parse the attachment contents to update my database. (Just one example will help).

I have been using SQL for years and have used SQL Mail to send out automated messages but I have never tried this.

Thanks for any help"
   

- Advertisement -