Excel example

kenl
kenl Member Posts: 182
edited 2005-05-11 in NAV/Navision Classic Client
Hello,

I need to import Customer table from an excel file. Can anyone tell me how to read an excel file from Navision ?

Thanks,
Ken

Comments

  • kine
    kine Member Posts: 12,562
    Look into Excel buffer table, there are all needed functions... second way is to export into CSV and import through DataPort...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kenl
    kenl Member Posts: 182
    Hello,

    Yes, I know there is a "Excel buffer" table. But how do I use it ? Do I create a dataport, using Excel buffer as the data item ?

    Any sample ?

    Thanks,
    Ken
  • kine
    kine Member Posts: 12,562
    Look at report 81 or 7131.

    If you look to the functions defined in the Excel buffer, you will see how to use it (the functions open excel file, read sheet into buffer - into the table and you process the table...)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kenl
    kenl Member Posts: 182
    Thank you for your information.

    Ken

Categories