topic Re: How do I link QV to a Access database on my C:? in QlikView

How do I link QV to a Access database on my C:?

Wed, 16 Jan 2013 17:16:29 GMT

I am trying to link to an access database C:Payroll.mdb. I know I have to type something in "Edit Script". What should I type in edit script or if you could point me to an article?

I know I can link to a table within the access database, but can I also link to a query?

Thanks in advance for your assistance.

Tim

Re: How do I link QV to a Access database on my C:?

danielrozental — Wed, 16 Jan 2013 17:27:14 GMT

Check this video http://www.youtube.com/watch?v=Kx4v7TEgbkY

Re: How do I link QV to a Access database on my C:?

vgutkovsky — Wed, 16 Jan 2013 22:13:55 GMT

I don't think there's any way you can link to a query, unless your query is contained within a table (may be a cool idea to do this, as I've never seen it done).

Regards,

Vlad

Re: How do I link QV to a Access database on my C:?

Tue, 22 Jan 2013 22:40:52 GMT

I found out that the problem was that I had to click the box on the inital screen to "Force 32".

Re: How do I link QV to a Access database on my C:?

Tue, 22 Jan 2013 22:40:59 GMT

I found out that the problem was that I had to click the box on the inital screen to "Force 32".

Re: How do I link QV to a Access database on my C:?

hic — Tue, 22 Jan 2013 23:10:55 GMT

Force 32 should do the trick: There is no 64-bit ODBC driver, so you need to use the 32-bit ODBC driver.

The following script works on my computer:

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Northwind.mdb];

SQL SELECT Address,

City,

CompanyName,

ContactName

FROM Customers;

but it depends on what your Data Source (Edit Script -> Tools -> ODBC Administrator 32-bit -> User DSN) is called and what data you want to load.

HIC

Re: How do I link QV to a Access database on my C:?

Wed, 23 Jan 2013 21:21:28 GMT

You are absolutely correct.

Thanks for the input.

Re: How do I link QV to a Access database on my C:?

Thu, 24 Jan 2013 18:06:04 GMT

Henric

Do you have any idea when say the graph below which is for a particular VP’s overall OT% for his entire division to jump to another chart that I have built (see second chart below) so that the VP can see the % by department – sort of a qlick to drill down to the detail.

Thanks

Tim

Jump to this chart when I click on one of the lines in the above chart

Re: How do I link QV to a Access database on my C:?

hic — Fri, 25 Jan 2013 20:28:34 GMT

I think you should make a drill-down group of the two fields ([CostCenter Description] and [VP Name]). You can do this under Settings -> Doc. Properties -> Groups. Then use this as second dimension in the graph.

HIC

Re: How do I link QV to a Access database on my C:?

Mon, 04 Feb 2013 16:29:03 GMT

It is possible to get data from a query in Access as it is possible to connect to a view in SQL Server or Oracle.

You simply make sure the the View setting is checked when you explore the tables an you can see any table, view, query in the database.

John