How To Import data from Excel into Navision table fields

visgold

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 , 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

kine

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)

zarryn

If you are using version 3.70B then I would recommend looking at the new Excel mapping utility included in the Industry Templates feature.

juanborras

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