topic File .DBF still not working... in QlikView

File .DBF still not working...

Anonymous — Mon, 11 Oct 2010 16:31:57 GMT

Hi everybody,

I'm trying to load a .DBF file on a project, but with http://community.qlik.com/forums/t/20045.aspx I've this error:

SQL Error:[Microsoft][Driver ODBC dBase] Il modulo di gestione di database Microsoft Jet non è riuscito a trovare l'oggetto 'PG45010000910'. Assicurarsi che l'oggetto esista e che il nome e il percorso siano digitati correttamente.

SQL Scriptline:

SQL State:S0002

SQL SELECT *

FROM `C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\DESKTOP`\PG45010000910

and with http://community.qlik.com/forums/t/27496.aspx I have:

ODBC read failed
SQL SELECT *
FROM pg45010000910

but the strange thing is that with the tool "building the select instruction" I'm able to see the file content as shown in picture:

I've to underline that i can see everything with MsExcel...

Anybody can help me?

Thanks in advance.

Marco

File .DBF still not working...

Emmanuelle__Bustos — Wed, 28 Mar 2012 00:07:20 GMT

Hello m.paoltroni

Have you tried using the driver "Driver do Microsoft Visual Fox Pro" BUT specify when create the DSN that there are Tables instead of BD and set the directory where the files .bdf are stored? so you can create the connection with QV using that DSN.

Regards!

File .DBF still not working...

richard — Wed, 28 Mar 2012 11:11:49 GMT

Ciao m.paoltroni,

Download the FoxPro ODBC driver here

http://msdn.microsoft.com/en-us/vfoxpro/bb190233

Install it and then use the ODBC CONNECT32 statement in you Qlikview script.

Re: File .DBF still not working...

andries_bos — Wed, 28 Mar 2012 12:14:48 GMT

I normally test my ODBC links- extraction with Excel using the MS Query (load external data). In this way you have another testin option outside of qlikview just to verify your odbc connection.

ODBC driver in use was Microsft access dBase Driver.

I also had to add, on 64 bit OS server (and 64b pc), my odbc driver manager using the 64 bit odbc utility ( C:\Windows\SysWOW64\odbcad32.exe ).