topic Re: How to create QVD from microsoft access file? in QlikView

How to create QVD from microsoft access file?

Mon, 08 Dec 2014 10:06:55 GMT

Hi,

I have problems to create the QVD file from Microsoft Access file?

I'm still new in Qlikview.

Can anyone help me?

Regards,

Kama

Re: How to create QVD from microsoft access file?

tresB — Mon, 08 Dec 2014 10:10:53 GMT

Create an OLEDB connection and use that connection string.

Re: How to create QVD from microsoft access file?

ashfaq_haseeb — Mon, 08 Dec 2014 10:11:01 GMT

Hi,

Try like this

Your Connection string
Class:
LOAD `Account Class`,
    `Account Class ID`;
SQL SELECT *
FROM `Account Class`;
STORE Class into Class.qvd(qvd);

Regards

ASHFAQ

Re: How to create QVD from microsoft access file?

prma7799 — Mon, 08 Dec 2014 10:17:18 GMT

Hi,

i- Connect Microsoft Access for fetching table which is present in the database see below

ii-Go to Select option which highlighted in red mark below

iii-STORE Tab1 into Tab1.qvd;

Thanks,

Re: How to create QVD from microsoft access file?

prma7799 — Mon, 08 Dec 2014 10:23:50 GMT

Re: How to create QVD from microsoft access file?

prma7799 — Mon, 08 Dec 2014 10:41:29 GMT

Hi,

Can you close this thread by marking it as answer.

Regards

Prashant

Re: How to create QVD from microsoft access file?

its_anandrjs — Mon, 08 Dec 2014 10:58:34 GMT

Hi,

Make the connection string with the ODBC connection

ODBC CONNECT TO [MS Access Database;DBQ=C:\EData.accdb];

Descript:

SQL SELECT *
FROM Descriptor;

Store Descript into Descript.qvd;

Regards,

Anand

Re: How to create QVD from microsoft access file?

prma7799 — Mon, 08 Dec 2014 11:00:41 GMT

Hi,

Can you close this thread by marking it as answer.

Regards

Prashant

Re: How to create QVD from microsoft access file?

Chamini2020 — Fri, 21 Aug 2020 09:22:43 GMT

Can you help me find the error in the below , as there is an error when loading when creating QVD file from ACCESS

LIB CONNECT TO 'QTSales';

REM LOAD ID,
OrderID,
ProductID,
Quantity,
Sales,
Discount,
"COS",
GP;
SQL SELECT ID,
OrderID,
ProductID,
Quantity,
Sales,
Discount,
"COS",
GP
FROM "E:\EXE\MY DASH BOARDS\EXERCISE 3\DATA\QTSales.mdb"."Order Details";

Store OrderDetails into 'lib://QTSales/OrderDetails.qvd' (qvd);