topic Re: Extracting data from FoxPro database in QlikView

Extracting data from FoxPro database

Thu, 14 Jun 2012 11:55:48 GMT

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

rbecher — Thu, 14 Jun 2012 21:14:21 GMT

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

Thu, 14 Jun 2012 21:45:39 GMT

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

pablolabbe — Fri, 15 Jun 2012 03:35:09 GMT

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

rbecher — Fri, 15 Jun 2012 06:27:02 GMT

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

- Ralf

Re: Extracting data from FoxPro database

Fri, 15 Jun 2012 06:43:37 GMT

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

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

Fri, 15 Jun 2012 06:45:25 GMT

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

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

rbecher — Fri, 15 Jun 2012 07:09:27 GMT

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

- Ralf

Re: Extracting data from FoxPro database

NZFei — Thu, 28 Jun 2012 21:54:52 GMT

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