Import from Excel

dynamics_prasanth

Is there any option in NAV 5.0 to import data from Excel?
eg: One of my clients has generated a chart of accounts in excel and given it to me. Is it possible to import this data to a new database? or is it required to enter the whole thing once again into NAV?

satraja2004

Hi,

Take a look at the following link

http://www.mibuso.com/forum/viewtopic.php?f=23&t=30609

ssingla

You can create a dataport with relevant fields of G/L account table (table 15), then rearrange the excel file (if required), convert the excel file in csv format and import by running the dataport.