p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

proasp_codeclinic thread: ASP & SQL Server Query

Message #1 by "Deepak Parthasarathy" <deepakp@n...> on Mon, 12 Mar 2001 13:10:34 +0530
    I need some help on this task that has to be automated on SQL Server.

I need to send mails (probably using xp_sendmail) on insert in a particular
table with some database information
in the email. Now this email is sent a different system that needs this
data. The second
system process the data sent by us & sends back some more data by email.
(Again from SQL Server).
Can I read the email back using SQL Server & update my tables.

Also, I need to read XLS files (But we don't want to have Excel installed on
the server!!).
I know that we can have a DSN pointing to an XL file & read data from that
file. Any inputs
on this methods??

Thanks in advance...

Deepak Parthasarathy M
NCMR Technologies Pvt. Ltd.,

        \\- - -//
        (  @ @  )
          . .. . . . . .
mailto: deepakp@n...
-------oooO---(   )-----
      (   )    ) /
       \ (    (_/

  Return to Index