Import data from Excel format

YUAN
YUAN Member Posts: 7
edited 2004-08-27 in Navision Attain
Hi,

I'm a beginner to use Navision system since my current company just bought the package. I need someone help for import data from excel worksheet. Our current system is using SQL database to store data and use excel format to export data before import into navision database using dataport. Can anyone taught me how can dataport format can import data from excel format ? Thanks..... :D

Comments

  • Albertvh
    Albertvh Member Posts: 516
    Save your excel file as a "CSV" type and write a dataport so that all the validations are done by Navision. :D
  • PEzechiels
    PEzechiels Member Posts: 83
    What i have to add to what Albertvh wrote is that you have to make sure that your layout in excel is the same as in navision .
    also take alook at what which fields your primary key consists of and make sure that every record in excel in unique ,other wise you will get an error that the record already exists.
  • YUAN
    YUAN Member Posts: 7
    Thanks your information. If i set a primary key in one of the field, for example, customer code in buyer table, my salesman code can be repeat cause one salesman can have many customer under their accounts, in this scenario, is it impossible to save this kind of excel worksheet as CSV type ? :(

Categories