|
Home > Archive > BizTalk Server Applications Integration > April 2005 > biztalk 2004, email, excel and database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
biztalk 2004, email, excel and database
|
|
|
| is it possible to create an orchestration that would use data from excel file
that is attached to an email? i found a free pop3 adapter
(http://www.muranosoft.com/products/...op3Adapter.aspx) and is it
possible for biztalk to extract an attachment (excel file) from an email, use
data in that attachment for an orchestration, and on the send port put some
of that data in a database?
should i do it with web services or...
| |
| Saravana Kumar 2005-04-12, 2:49 am |
| There might be a way to detach the attachment from email using the POP3
adapter. But Biztalk doesn't have any functionality by itself to handle
Excel fle.
Either you need to implement your own custom pipeline component to handle
it.
Or you can consider ItemFields document parser (http://www.itemfield.com)
Cheers,
Saravana [MCP - Biztalk Server 204]
http://saravanakumarmv.blogspot.com
"Nedim" <Nedim@discussions.microsoft.com> wrote in message
news:D0BE3DB2-88B1-44D4-A680-55A7BC463B20@microsoft.com...
> is it possible to create an orchestration that would use data from excel
> file
> that is attached to an email? i found a free pop3 adapter
> (http://www.muranosoft.com/products/...op3Adapter.aspx) and is it
> possible for biztalk to extract an attachment (excel file) from an email,
> use
> data in that attachment for an orchestration, and on the send port put
> some
> of that data in a database?
>
> should i do it with web services or...
|
|
|
|
|