How to import data from excel file to navision table

slavadem

How to import data from excel file to navision table. Can you explain a simple code how to do it.

Luc_VanDyck

Have a look at the topic "Tips&Tricks: Excel Automation" in the forum Navision Tips & Tricks. This will get you started. Be sure to select "Show all topics" first, otherwise a blank screen is displayed.

John_Tegelaar

Or use Evaluate("Non-text Field",Format(Excel Value)) to convert the text from the Excel cell. Works for decimal, integer, boolean, etc.

John

slavadem

It's ok! But some fields don't import because of error: "Can't convert data from text to boolean, or decimal"


"Allow Invoice Disc.":=Format(xlWSheet.Range('M1').Offset(row,0).Value);

"Unit Price":=Format(xlWSheet.Range('P1').Offset(row,0).Value);

Luc_VanDyck

Try this:

"Allow Invoice Disc.":=Format(xlWSheet.Range('M1').Offset(row,0).Value) = 'Yes';

That is if there is a 'Yes' in your Excel stating you want discount.