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
Hi,
    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

Deepak Parthasarathy M
NCMR Technologies Pvt. Ltd.,
Koramangala,
Bangalore-95.
Phone:080-5526572

        \\- - -//
        (  @ @  )
------oOOo-(_)-oOOo-----
          . .. . . . . .
mailto: deepakp@n...
           deepaksarathy@h...
              Oooo
-------oooO---(   )-----
      (   )    ) /
       \ (    (_/
        \_)


  Return to Index