How to Link SAP Business One Data to Excel | Tutorial

Поділитися
Вставка
  • Опубліковано 6 лис 2024

КОМЕНТАРІ • 19

  • @alimahdi2679
    @alimahdi2679 2 роки тому +1

    thank you very much you have no idea how this video help in simple words it let me keep on my job seriously thank you.

  • @gopalkrushnakapatel2223
    @gopalkrushnakapatel2223 4 роки тому +1

    Really nice explanation,

  • @riya745
    @riya745 3 роки тому +2

    this is exactly what i need... Thank youu

  • @gulsherjaved3555
    @gulsherjaved3555 3 роки тому +1

    nice work from pakistan

  • @jsalas5059
    @jsalas5059 3 роки тому +2

    HI, please, where can I find the driver to see the option Hana in Excel?.. many thanks

  • @jimaklos
    @jimaklos 2 роки тому

    Hi. Thank you very much for this useful video. 2 questions that I hope you can help me with. (1) can we load the information for multible databases(companies) and if possible include the corresponding database name as a column in the table with the data (2) Which table/tables do I use to load general ledger(journal entries posted) data? Thanks again.

    • @ProjectlineCa
      @ProjectlineCa  2 роки тому

      Hi Demetris, the answer is yes, you can do this. The way it's shown in this example is that the database of interest (IE schema) has been pre-selected through the excel power query framework. In theory, you can do a different query with different data source specifications to have similar queries coming into excel. There is more than one way to do this, and it may be hard to explain it succinctly. We might consider doing an explanation in a future video.

  • @DavidInternacionalC
    @DavidInternacionalC 3 роки тому

    Hey, this info is just great. One question, is it possible to build this connection but have both show data and also input data back to the HANNA DB?

    • @ProjectlineCa
      @ProjectlineCa  3 роки тому

      This basic connection is a read-only type of thing.

  • @parawalterguatemala
    @parawalterguatemala 2 роки тому +1

    Thank you.

  • @jorgediaz1405
    @jorgediaz1405 10 місяців тому

    how do we do it if we access sapb1 from a remote desktop? is that why I cant see the hana database in excel?

  • @ArunKumar-j5x9t
    @ArunKumar-j5x9t Рік тому

    Hi Sir I cannot see HANADB in Excel get data why it is not showing can you please help me out

  • @shankarkumawat2134
    @shankarkumawat2134 3 роки тому

    Nice One

  • @ChiChi-sw5iu
    @ChiChi-sw5iu 2 роки тому

    Hi Sir. How do we download MDX? I can't find it

  • @rodrigoduda5113
    @rodrigoduda5113 3 роки тому +1

    TKS

  • @collinsmakumana7303
    @collinsmakumana7303 2 роки тому +1

    ODBC😉😉