1 Reply Latest reply: Nov 23, 2011 6:41 AM by Enrique Bernat RSS

    Extracting data from a Navision 3.56 native database

      Hi!
      I'm trying to import data in to Qlikview from a Navision 3.56 native database. I have a problem with some of the field names ending with a dot eg.:
      "Sales order no.". When I try to import this field Qlikview is stalling. Does anyone have an idea how to avoid problems when importing such data? I'm using an ODBC connection to access the database. See example below:
      ODBC CONNECT TO Navision (XUserId is TOOCYaZMKTUB, XPassword is XDZGJWVMOLZEB);
      SQL SELECT
      "Amt. Incl. Sales Tax",
      "Department Code",
      Description,
      "Line Discount Amount",
      Quantity,
      "Sold-To Customer No.", THIS LINE IS CAUSING
      "Unit Cost ($)"
      FROM "Sales Invoice Line";
      Thanks!
      Henrik