datas from Excel to SQL

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › datas from Excel to SQL

Viewing 2 reply threads
  • Author
    Posts
    • October 27, 2005 at 11:07 AM #12124
      community-content

        hai friends,

        I want to transfer the datas from Excel to SQL via biztalk server 2004.
        can anybody give me a clue to start my project.

        I defined the xml structure and mapping.

        I need the following details
        1)How to configure receive and send ports.
        2)Which adapters to use
        3)Do I need to write any C# code

        Can anyone help me?
        thanks in advance

        • August 25, 2006 at 1:32 PM #12125
          community-content

            One possibility below, from Matt Meleski — it’s somewhat inelegant but I plan to give it a try:

            { and I can’t give you this URL, because of the spam filter, so just google Matt Meleski, BizTalk, and \”Custom Pipeline Component for Processing DBF, Excel\” }

            • August 25, 2006 at 1:34 PM #12126
              community-content

                I have wasted an incredible amount of time, trying to create a post with this information that passes the infernal spam filter.

                There is a too-expensive solution that nonetheless may be just what some developers might need to achieve this, you can find it by googling FarPoint and Excel and BizTalk

          • October 28, 2005 at 4:48 AM #12123
            community-content

              Hello.

              Well, Biztalk does not support Excel files so you will either need to build a custom adapter, buy one (do not even know if one exists), or transform your Excel file into Xml to send it into Biztalk by some other external project.

              What I have done in the past was to use a C# component to read the Excel document and send Xml messages to Biztalk. Then, we just used an Xml Receive Port and in your case a SQL Send Port. You can define your map and use it on the Receive Port (or Send).

              Hope this helps.

            • November 10, 2020 at 3:18 PM #49687
              biztalkgurus

                The Prettiest • Brigit Young • 9781626729230

            • Author
              Posts
            Viewing 2 reply threads
            • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.