notconfident
Programmer
I have an Access Table called LogTable which is updated from various events within the Database. It is quite a simple table with 5 fields, Number, Text, Date/Time, Number then Text. I can export the table to Excel ok but sometimes the output stops at a particular record (call it Record x) which looks ok. Further records are in the table but dont get exported. If I compact the database new records will be exported but there is a gap in the Spreadsheet from Record x to after the compact date. I assume there is some sort of "end of file" character that I can't see but why does the compacting change things.