Import data from Excel

[IanMonk]

I am new to Navision so please bear with me!

Is it possible to import data from Excel into Navision?

Would I need to save it as CSV file?

Any help would be appreciated.

Thanks

Ian
Bolton
UK

[Tsang]

Yes. You can take a look on Budget function in Navision as an example.

[George Nikolovski [MSFT]]

Hello Ian,

To add some more light on this matter in general the Navision product does
integrate with Microsoft Excel and wherever possible there are import/export
menu options built into the product.

In addition please be aware that the use of dataports enables you to take
the data from Excel (converted to .csv format) wherever the aforementioned
import/export menu options are not built in and populate the relevant tables
within Navision.

I hope this helps.

[Victor Stehmann (MSFT)]

At the moment so called "industry templates" are released together with
3.70.B. They include a mapping tool to create Excele templates, which can be
filled out and imported into Navision. The import and export can be managed
from the Setup Checklist.
I think this tool will help you with your task

/Victor

[Koos Splinter [MSFT]]

Hi,

From a code point of view, it's quite easy to access Excel by using a
variable of the type "Automation Server", and then choose "Microsoft Excel
[xx] Object Library", where xx stands for the current Excel library version
that is on your system. Through this you can create an instance of the Excel
application (or use an existing instance), open/create workbooks and sheets,
read and write data, etc. If you are familiar with using Excel from other
platforms, it is quite easy to understand the interface that is being used
between Navision and external applications such as Excel. The base
application already contains examples of this in various places.

Hope this may be of help to you.

Regards,

Koos Splinter [MSFT]