Open Excel File and import into a table

LeoNav

Hey,

I read a lot of topics on it but is it possible to import directly from Excel to a Navision table ?

I saw terms like ExcelBuffer, OCX etc but what is the easiest way to do it ?

FSmeets

Use the Data Migration option via Administration > Application Setup > Company Setup > Data Migration
Best is to export the table first, so you have the correct format of the excel file.

LeoNav

Hi,

Thank you but I would like to use the ExcelBuffer functionality. But it seems to have a problem with the date format. Though it is ok. I don't understand.
I read that there is maybe a bug with the 5.01 version ?? Is it possible ?

Savatage

take a look at this..
http://www.mibuso.com/dlinfo.asp?FileID=811