How To Import data from Excel into Navision table fields

visgold
visgold Member Posts: 21
edited 2005-04-07 in Navision Attain
Dear

I am trying to import data from excel into navision using excell buffer table and report already existed (Ask for file name and sheet name).

That works fine but the problem i am getting is that

I want to import data from first two column (ie A , B) from excel sheet into my navision table in 2nd and 8th (column or field) which doesn't work as if i write these data in B and H column in excel sheet , only then it works.

Pls give me any suggestion to solve this problem that where i have to make changes in report or excel buffer table ie i can import data from excel sheet into navision.

Thanks

Visgold

Comments

  • kine
    kine Member Posts: 12,562
    In the report is the position somehow fixed. You must change the report to be able to import data from another columns... (there will be some filtering or counting for that)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • zarryn
    zarryn Member Posts: 29
    If you are using version 3.70B then I would recommend looking at the new Excel mapping utility included in the Industry Templates feature.
    Zarryn
  • juanborras
    juanborras Member Posts: 35
    Hi!

    I'm from Spain, I just downloaded US_NAV_370_B to take a peek to the Excel Mapping Utility... it's great, but it is not available in the spanish version :( I've tried to change to our license in order to export this utility and import it into the spanish version, but the ES license doesn't work on US license, could anybody export such utility to a fob or txt file and mail it to me? Is this possible or it is against some copyright thing?

    thanks
    Juan

Categories