Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extracting data from FoxPro database

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

8 Replies
rbecher
MVP
MVP

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

Astrato.io Head of R&D
Not applicable
Author

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.

pablolabbe
Luminary Alumni
Luminary Alumni

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

rbecher
MVP
MVP

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

- Ralf

Astrato.io Head of R&D
Not applicable
Author

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.

Not applicable
Author

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.

rbecher
MVP
MVP

I think this is only a matter of configuration. Just send me the details: ralf.becher@tiq-solutions.de

- Ralf

Astrato.io Head of R&D
NZFei
Partner - Specialist
Partner - Specialist

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