All records are not loading from access table when loading into qvw?

[#1]

Hi,

I have ms access database tablw which have records 60,000 when I am loding into qvw it is sloading only 12,000 records. can anyone please suggest why there is less count of records loading.

Thanks.

[#2]

Thanks that's exactly right. what if I want the Chinese records also. would it be possible to get those also?

[ashfaq_haseeb]

Hi,

try something like this

English:

LOAD

    ID,

    ...

   ....

  ....;

SQL SELECT *

FROM data;

where ID not in (453015579 ,20857);

store English into English.qvd(qvd);

Chinese:

LOAD

    ID,

    ...

   ....

  ....;

SQL SELECT *

FROM data;

where ID in (453015579 ,20857);

store Chinese into Chinese.qvd(qvd);

If it work properly then use below

Table:

LOAD

    ID,

    ...

   ....

  ....;

SQL SELECT *

FROM data;

where ID not in (453015579 ,20857);

concatenate

Chinese:

LOAD

    ID,

    ...

   ....

  ....;

SQL SELECT *

FROM data;

where ID in (453015579 ,20857);

store Table into Table.qvd(qvd);

Hope it helped.

Regards

ASHFAQ