import data to Excel from Access using SQL query - some records are missing

Question

Hi,

this is rather an user question, so please excuse my description.

I have finance database in Access. For other users I export the data to Excel using SQL query. All of the columns are exported. The tables in Access and Excel look 1:1.

The problem is that some of the records (string of partner's name) are not exported to excel. And what is worse that the same string (= same partner's name) is perfectly exported on other rows but not on two or three others. I can see in Access that the field is filled, that the name of the partner is the same (imported from accounting system) as in other rows. But in Excel there are few rows where the corresponding cell is empty. This is a problem of only little few records in a very large database.

Before digging deeper in the query (which wokrs perfectly for 99,999999999% of the records), have you ever faced such a mistake? I believe it must be caused by some minor stupid thing that I am overlooking.

Thank you very much,
Václav

Answer 1

Is it only this one field that has gaps in it? That is, only the partner's name field; no other fields have gaps?

Is there any correlation between where those gaps are and their relative position with regard to previous or subsequent records with the same name?

What is the datatype of the field in Access?

How do you perform the export?