How to Import data from Excel file

Kau_147
Kau_147 Member Posts: 84
edited 2014-02-28 in NAV/Navision Classic Client
Dear All,

I am migrating the database in same version NAV 4.0.3.

I am taking all data in excel from old database & filtered only required data.

Now I want to import the data in table without using dataport.

No. of records might be 50000-60000.. So any other way to import data in New database from excel file.. like SQL etc.

Please help!!!! ](*,) ](*,)

Thanks in advance.
Best Regards,
Kavita Mutha

Comments

  • geordie
    geordie Member Posts: 655
    For this amount of data Excel Buffer table would have remarkable performance problems.
    Why can't you simply save your Excel file in a .csv and import it with a dataport, which will be certainly faster?
    * Daniele Rebussi * | * Rebu NAV Diary *

Categories