Automation from Excel

oodai

Hi Can i import excel to Navision as a end user of the product.
if it is not possible as a end user to create automation how can develop this.
Exampl I get standard excel files from customers, which needs to be updated in Navision. How can this me automated

archer89

you could import data using dataports.
otherwise use the Microsoft excel automation within a codeunit or a report to read data from an excel or csv file.
also check if you have a table called excel buffer.

kine

Which version of NAV you are using? You have posted into Navision Financials category, which means version 2.x and I am not sure, if it is true (because you cannot run this version on new windows etc.).

Newer versions have the Excel Buffer table, which has functions to read excel sheet and than you can go through the values in the table and process them. But if you are end user and you need to import some simple tables from the excel, you can use the csv way (using dataports) or you can go around by using the excel automations (as @archer89 answered) or you can try to use the excel as a "database source" and connect it through ADO (more complex way)...

oodai

Hi kine,

Please find attached screen prints of navision screen and version. Also please do let us know if there is a tool which can directly pick data from excel to Navision

kine

No by default...

oodai

Hi kine,

Please find attached screen prints of navision screen and version. Also please do let us know if there is a tool which can directly pick data from excel to Navision

joshuasung

Importing through CSV probably the cheapest solution, but need to convert Excel to CSV. Otherwise, need to program to take excel import.