Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the reply GilbertQ.

 

Actually me too doing the same thing.

 

But i thought there will be a direct solution for this.

 

 

GilbertQ's avatar
GilbertQ
Super User
8 years ago

Hi Anonymous

 

No problem I do not think that there currently is any easier way.

  • J_Tanna's avatar
    J_Tanna
    Frequent Visitor
    8 years ago

    Hi GilbertQ 

    I am facing same problem. But not able to understand what you want to convey. Would you like to convey it in more detail? That could be a big elp for me.

     

    Thank You.

    • GilbertQ's avatar
      GilbertQ
      Super User
      8 years ago

      Hi J_Tanna

       

      What you would need to do, is to go into the Query Editor, and create a new connection to your SQL Server Table.

       

      Then once that is created you would then go into the Advanced Editor and copy all the M Code.

       

      Next you would then need to go to your Excel Source, and replace all the steps that refer to the Excel Source and then replace it with the copied code from the SQL Server table.

      • christianfcbmx's avatar
        christianfcbmx
        Post Patron
        7 years ago

        hI GilbertQ is there a tutorial ro something where to watch?,,,Im trying to do this and I cant.

         

        Thanks in advance.