How to get all records in straight table without missing?

[#1]

Hi,

I have a straight table with data. The columns are

Name, DateEntered, DaysinQueue.

All the records are updating from access database. But there ate two records in access database with DateEntered as 28/04/2014 12:16:36 and another record with DateEntered as 28/04/2014 13:43:18. Only these two records are not updating in the file.

Could anyone suggest me how to get this records?

Thanks.

[#2]

Thanks. I tried. These two dates are not populating. How can I change this to get the records?

[#3]

Where I can add this as I have this table in load

Tbl:

LOAD Name,

     DateEntered,

     DaysinQueue

FROM

Extractor\Tbl.qvd

(qvd)

[sudeepkm]

Almost everyone has suggested a reason or a cause of the record not being visible even after that you do not see it then it would be great if you can share your QVW and can let us know which exact record (record ID) you have in the database and not being pulled to the QVW.

[suheshreddy]

Tbl:

LOAD

Rowno() as anyfield, Name,

DateEntered,

DaysinQueue

FROM

Extractor\Tbl.qvd

(qvd)

[#6]

Thanks. The problem is the database there are 4463 records. The qvd loading only 4365 records. How can I get complete set of reords in to qvd?please help

[sudeepkm]

can you paste your data load script here?

[#8]

Tbl:
LOAD Rowno() as Rowno,
    ID,
    Name,
    DateEntered
SQL SELECT *
FROM tblCustomer;

STORE Tbl INTO C:\Extractor\Tbl.qvd;

DROP TABLE Tbl;

EDIT: It is showing a message as ODBC read failed after loading 3016 records. Will this be the problem?

[sudeepkm]

could be. if you have database interface tool like sql+ or sql developer then try to run the same script in there and check if you are getting the same error or not.

you may also check the detail error message.

[its_anandrjs]

Check your access database may be problem is there after 3016 records.

[#11]

unfortunately I don't have any other environment to run this. It is not showing any detailed error message it is showing only QVX_Unexpected_End_of_data. as in attached. How can I set this please help me.