How to import Excel spread sheet into Navision.

Business Central/NAV Developers Forum
1

Hi All,

I want to import data from Xl-Sheet into Item table , i set the followng propertys as follows…

import=yes ;

File Format=variable & left the “field start delimiter” , “field end delimiter” ,"field seperator " propertys as default.

when i run the dataport , am gettng some garbage value …

Plz help me in this case…

wht are the other propertys tht i need to set …

And 1 more thng , during the runtime i shd be able to select either to import / export , how can i achieve this…

Regards

venu

2

Hi Venu,

Dataport are designed to import Acsii files not Excel file. Export the speadsheet to CSV first and use FileFormat = Variable.

If you specify a value for the Import property then you will not be asked for the Import/Export option at runtime.

I suggest that read the Application Designer’s Guide (w1w1adg.pdf) on the product DVD for a detailed explaination of dataports.

3

Save the filename in .cvs extension and Save as type = CVS(Comma delimited) then try againg

0842.Cvs.JPG
0842.Cvs.JPG779×494 43.2 KB

4

Hi Venu,

Instead of using start and end delimeter direclty write a code on afterimport trigger to import data into table using .csv files

Its easier

Regards

Amol

5

see venu u cant import data from excel sheet directly to navision so to do that there are many tools which u can get from mibuso.com k

this is mitra