How to import data directly from Excel

There exist some ways to do it. Easiest of them is, I think, save your Excel sheet in some kind of CSV file and create simple dataport to import it. You can also use Excel automation, but it needs a bit more knowledges.

Exactly in what table are you trying to insert?

vyanku, when you import a record into a table you have to populate the primary key(s) in the table, (the tables unique field(s)) in this case it's No.

So you need to make sure each record in the the *.csv file you're importing from has a unique account no.

hope I've helped.

If you are using version >= 4.0 SP1 then use Mapping Form. Its a good functionality and import data directly from Excel.

Check wich object gives the error and try to recompile it , that could help ...

There is a strange thing about this mapping tool that it gives error in few cases and in few it runs perfectly. Try the following steps , it might help:

Create a Code, define the table number, and give a new file name. Specify a mapping group. First Data Row as 5 (It should be 5 though I do not know the reason but if I change it, it gives error). From the function run "Insert Fields from Table" and do not select auto coloumn. Delete the fields not required by you. Then click "Line" button and select Auto Coloumn. Click Function and select "Export Definition". Ensure that no excel worksheet is open at that time. Once the definition is exported open the file and copy paste all your data in this sheet. After you are done on the mapping form select the file name again (Do remember to do it ) and then import. I hope there will be no problem. Also the computer you are using should have Microsoft Office with Excel installed on it.

Have you reselected the file name??

I've been working with the same problem, and found out that if there is an option-field in the table, you try to import, you get the message.

Try to avoid importing option fields. Just remove the mapping to that field

Regards
Aksma

I'll try to explain a little bit better, what to do about the error:

"Message is for c\cal programer"
Could not invoke the member name.The OLE control or outomation server returned an unknown error code"

This error comes from an option field, where you have the text for the option instead of the code. Code is 0,1,2...n.

Try to replace the text in your table with the code instead, before importing your excel-file to NAV.

If you don't know, which fields are option-fields, start with "export definition". In the first row, where you have an option field in a column, you will see at red triangle in the excel-file, meaning a remark. Open the remark and you will see the option list.

=D>