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