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.

[alexandros17]

There must be an unrecognized character that stop the loading ...

[#3]

How can I know this?

[ashfaq_haseeb]

Hi,  try by adding flag to your load script.

load

F1,

F2,

1 as Flag,

F3;

from <AccessDB>.

Hope it helped.

Regards

ASHFAQ

[#5]

Thanks. tried still loading 12,000

[ngulliver]

Do you get an error message or does it simply stop ?

Were you able to identify the last record that was read in successfully?

[#7]

it is showing ODBC read failed when I am loading all columns in the table to qvd

[ashfaq_haseeb]

Hi,

Try by connecting OLEDB connection.

Did you enabled document log?

what does log says?

Regards

ASHFAQ

[#9]

Hi, Amelia2000

You can upload your log for our investigation.

Regards,

Alan

[#10]

please see attached.