How to create QVD from microsoft access file?

[#1]

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

[tresesco]

Create an OLEDB connection and use that connection string.

[ashfaq_haseeb · Accepted solution]

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

[prma7799]

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,

[prma7799]

[prma7799]

Hi,

Can you close this thread by marking it as answer.

Regards

Prashant

[its_anandrjs]

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

[prma7799]

Hi,

Can you close this thread by marking it as answer.

Regards

Prashant

[Chamini2020]

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);