2 Replies Latest reply: Oct 23, 2012 11:29 PM by Johannes Sunden RSS

    Excel data source

      Hi all

       

      How can I convert a bounch of same format Excel spreadsheets into qlikview

       

      data source like .qvd?

       

      I am a starter of qlikview, forgive my silliness.

       

      thanks

       

      Gloria

        • Re: Excel data source
          Johannes Sunden

          Hi Gloria,

           

          It's fine to use Excel files as data sources.

           

          If you want to load a table from a number of Excel files, with the same structure, in a folder you can use a load statement like:

           

          Load

               Field1,

               Field2,

               etc.

          From Path\*.xls;

           

          If you're new to QlikView, try using the load data from "Table Files..." button in the script editor to pull in one of the Excel files and then you can just replace the filename in the script with a * after you have gone through the steps of the load wizard.