Excel example

kenl

Hello,

I need to import Customer table from an excel file. Can anyone tell me how to read an excel file from Navision ?

Thanks,
Ken

kine

Look into Excel buffer table, there are all needed functions... second way is to export into CSV and import through DataPort...

kenl

Hello,

Yes, I know there is a "Excel buffer" table. But how do I use it ? Do I create a dataport, using Excel buffer as the data item ?

Any sample ?

Thanks,
Ken

kine

Look at report 81 or 7131.

If you look to the functions defined in the Excel buffer, you will see how to use it (the functions open excel file, read sheet into buffer - into the table and you process the table...)

kenl

Thank you for your information.

Ken