How to Import data from Excel file

Kau_147

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.

geordie

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?