>>I have a table with 1166 records. When I export it to MS Excel, it results 1140 records.
>>What can cause the reduced record number?
>
>How you export data?

File -> Export -> select the place where to export.
When I insert it to another table it behaves the same:

INSERT INTO bpeng_m SELECT * FROM bp_eng