Forum Discussion

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.

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago
        Hi there

        I do not know of anything off the top of my head, but that is a good idea for a blog post.
    • MAAbdullah_47's avatar
      MAAbdullah_47
      Helper V
      5 years ago

      Hi GilbertQ 

      I need your help , I need more details about this step I have the same case for the posted question but you didn't show any details , could give some details on how to do this migration steps?