topic Re: data from MS Access query is missing in QlikView

data from MS Access query is missing

Wed, 09 Sep 2015 14:20:31 GMT

Hi,

I am facing a strange problem. I am connecting to my MS Access using CONNECT32 and the connection is successful.
I am able to select my query and can see the fields name

my query:

but the issue is that the data is missing:

(when I tried it with other table from the same DB it works fine and I can see the data)

the query is not corrupted as I can see the query's data in access .

do you know how can I solve it?

thanks,

Mayan

Re: data from MS Access query is missing

m_woolf — Thu, 10 Sep 2015 14:37:38 GMT

What to you get if you do Select *

Re: data from MS Access query is missing

Wed, 16 Sep 2015 13:28:13 GMT

this is what i am writting:

CONNECT32 TO [MS Access Database;DBQ=C:\Users\Mayan\Aitan\תוכנת בית אריזה\תוכנת_בית_אריזה - 2015.accdb];
LOAD `Receive_ID`,
`Peak_year`,
ReceiveDate,
`Grower_ID`,
`Rec_Delivey_Num`,
PlotName,
FruitType,
DealName,
`Pack_Type`,
`Pack_Qty`,
`TotalWeight_Bruto`,
EnteringDate,
EnteringTime,
`First_Price`,
`Second_Price`;
SQL SELECT *
FROM `Copy Of ZZ_Rec_QV`;

but when i do reload the tables i receive are empty (although the query isnt empty in the access)

double click on the following also prvide no data (when i click on a table i do receive data)

please advise

Thanks,

Mayan

Re: data from MS Access query is missing

jonathandienst — Wed, 16 Sep 2015 13:31:55 GMT

Are you using an Access View or a physical table? Check whether the view returns any data and check the view's definition.

Re: data from MS Access query is missing

Wed, 16 Sep 2015 13:34:22 GMT

i am using a query (not a table). the query in Access does return data.

what do you mean by check "view's defenition"?