mibuso.com
Home› NAV/Navision Classic Client
Options

Excel example

kenlkenl 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

  • Options
    kinekine 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.
  • Options
    kenlkenl 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
  • Options
    kinekine 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.
  • Options
    kenlkenl Member Posts: 182
    Thank you for your information.

    Ken
Sign In or Register to comment.