8 Replies Latest reply: Jun 28, 2012 5:54 PM by Fei Xu RSS

Extracting data from FoxPro database

Eric Banini

Hi Everybody,

I need you guys to help me connect QlikView 11 to FoxPro database. This version of FoxPro database  doesnt allow export of data into any format but its own format .DBF. FYI, the client runs the FoxPro database  on Windows XP on a standalone PC. I collected the data in the .DBF format and tried loading it into QlikView but was not successful because the data displayed in QlikView did not make any meaning.

 

Guys, I need you to help me out on this as my client is getting impatience with me. FYI, am new to QlikView and need to learn more from this community.

 

Any help will be very much appreciated.

 

Thanks very much in advance.

 

Elikplim Banini

  • Re: Extracting data from FoxPro database
    Ralf Becher

    Hi,

     

    you can use the QlikView JDBC Connector with the HXTT DBF driver:

     

    http://www.tiq-solutions.de/display/enghome/ENJDBC

     

    http://www.hxtt.com

     

    This a very appropriate solution.

     

    - Ralf

    • Re: Extracting data from FoxPro database
      Eric Banini

      Thanks Ralf. I will try it and see what results it gives me. I will let you know if it works.

       

      Regards,

       

      Eric Elikplim Banini

      Applications Designer And Developer

      Tel: + 233 (0) 240 866 854

      Fax: +233 (0) 302 222 701

       

      infoCentriQ

      London Office: Level 33, 25 Canada Square, Canary Wharf, London E14 5LQ, United Kingdom

      Ghana Office:   132 Freetown Avenue, American House Road, East Legon, Accra, Ghana

       

       

      Discover Smarter Business

      This e-mail may be confidential and is intended solely for the use of the individual or entity to whom it is addressed.  If you are not the intended recipient and you have received this email in error then any use, dissemination, forwarding, printing or copying of this email is strictly prohibited; you should contact the sender by email return and then delete all the material from your system.  Any views or opinions presented are solely those of the author and do not necessarily represent those of infoCentriQ Ghana Limited. It is the responsibility of the recipient to ensure that this e-mail and any attachments are virus free. infoCentriQ Ghana Limited cannot accept liability for any loss or damage caused by software viruses or malware.

       

      infoCentriQ Ghana Limited, registered in Ghana with number CA-90,129 whose registered office is at 132 Freetown Avenue, American House Road, East Legon, Accra, Ghana.

       

      P Please consider the environment before printing this email.

      • Re: Extracting data from FoxPro database
        Pablo Labbe

        You can also try to use the OLEDB driver provided by microsoft. You can download it from here.

         

        http://http://www.microsoft.com/en-us/download/details.aspx?id=14839

         

        Good Luck

         

        Pablo Labbe

        • Re: Extracting data from FoxPro database
          Ralf Becher

          Unfortunately I never got this MS OLEDB driver to work with QV11, it's crashing..

           

          - Ralf

          • Re: Extracting data from FoxPro database
            Eric Banini

            Hi Ralf,

            It is not working. Could you please suggest other approach from your experience.

             

            Thanks.

             

            Regards,

             

             

            Eric Elikplim Banini

            Applications Designer And Developer

            Tel: + 233 (0) 240 866 854

            Fax: +233 (0) 302 222 701

             

            infoCentriQ

            London Office: Level 33, 25 Canada Square, Canary Wharf, London E14 5LQ, United Kingdom

            Ghana Office:   132 Freetown Avenue, American House Road, East Legon, Accra, Ghana

             

             

            Discover Smarter Business

            This e-mail may be confidential and is intended solely for the use of the individual or entity to whom it is addressed.  If you are not the intended recipient and you have received this email in error then any use, dissemination, forwarding, printing or copying of this email is strictly prohibited; you should contact the sender by email return and then delete all the material from your system.  Any views or opinions presented are solely those of the author and do not necessarily represent those of infoCentriQ Ghana Limited. It is the responsibility of the recipient to ensure that this e-mail and any attachments are virus free. infoCentriQ Ghana Limited cannot accept liability for any loss or damage caused by software viruses or malware.

             

            infoCentriQ Ghana Limited, registered in Ghana with number CA-90,129 whose registered office is at 132 Freetown Avenue, American House Road, East Legon, Accra, Ghana.

             

            P Please consider the environment before printing this email.

        • Re: Extracting data from FoxPro database
          Eric Banini

          Thanks Pablo. I will try it and let you know if it works. FYI, this version of FoxPro is not like Visual FoxPro from Microsoft.  I tried all those drivers available in Excel and Access but none of them were helpful. Please never give up try and send me a work around this problem as your help is very much appreciated.

           

          Thanks.

           

          Eric Elikplim Banini

          Applications Designer And Developer

          Tel: + 233 (0) 240 866 854

          Fax: +233 (0) 302 222 701

           

          infoCentriQ

          London Office: Level 33, 25 Canada Square, Canary Wharf, London E14 5LQ, United Kingdom

          Ghana Office:   132 Freetown Avenue, American House Road, East Legon, Accra, Ghana

           

           

          Discover Smarter Business

          This e-mail may be confidential and is intended solely for the use of the individual or entity to whom it is addressed.  If you are not the intended recipient and you have received this email in error then any use, dissemination, forwarding, printing or copying of this email is strictly prohibited; you should contact the sender by email return and then delete all the material from your system.  Any views or opinions presented are solely those of the author and do not necessarily represent those of infoCentriQ Ghana Limited. It is the responsibility of the recipient to ensure that this e-mail and any attachments are virus free. infoCentriQ Ghana Limited cannot accept liability for any loss or damage caused by software viruses or malware.

           

          infoCentriQ Ghana Limited, registered in Ghana with number CA-90,129 whose registered office is at 132 Freetown Avenue, American House Road, East Legon, Accra, Ghana.

           

          P Please consider the environment before printing this email.

  • Re: Extracting data from FoxPro database
    Fei Xu

    Ralf is correct. when I use QlikView 10 to connect to FoxPro using OLE DB, it works fine but when I use QlikView 11, it always crashes and stop working. I have submitted a case for that.

     

    Here I found a articel. Hope it can help you.

     

    http://community.qlik.com/docs/DOC-2814