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
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.,
\\- - -//
( @ @ )
. .. . . . . .
( ) ) /
\ ( (_/