Access not exporting all records from table

%3CLINGO-SUB%20id%3D%22lingo-sub-2145205%22%20slang%3D%22en-US%22%3EAccess%20not%20exporting%20all%20records%20from%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145205%22%20slang%3D%22en-US%22%3EOver%20the%20past%20several%20years%20I%20have%20exported%20some%20tables%20from%20one%20of%20project%20databases%20many%20times%20from%20Access%20into%20a%20text%20format%20to%20use%20in%20statistical%20analysis%20software.%20I%20must%20have%20these%20tables%20in%20text%20format%20(multi%20record%20format)%20to%20import%20into%20my%20other%20program.%20For%20some%20reason%20I%20can%20no%20longer%20export%20these%20very%20same%20tables.%20The%20exported%20text%20files%20have%20missing%20records.%20I%20have%20tried%20creating%20new%20versions%20of%20the%20tables%20using%20Make%20Table%20queries.%20I%20have%20tried%20closing%20Access%20and%20restarting%20it.%20I've%20tried%20rebooting%20my%20computer.%20I've%20tried%20to%20export%20the%20tables%20to%20Excel%20and%20then%20saving%20them%20to%20text%20or%20CVS%20format.%20They%20are%20missing%20records%20when%20they%20go%20to%20Excel.%20This%20has%20never%20happened%20before.%20My%20files%20are%20not%20too%20big%20(less%20than%2020%2C000%20records).%20They%20are%20not%20complex.%3CBR%20%2F%3EHas%20anyone%20else%20had%20this%20problem%3F%20Is%20it%20caused%20by%20a%20Windows%2010%20update%3F%20I've%20had%20other%20issues%20with%20Windows%2010%20(audio%20problems%2C%20Bluetooth%20and%20Wifi%20problems%20mostly)%20but%20no%20noticeable%20interference%20with%20other%20software.%3C%2FLINGO-BODY%3E
Occasional Visitor
Over the past several years I have exported some tables from one of project databases many times from Access into a text format to use in statistical analysis software. I must have these tables in text format (multi record format) to import into my other program. For some reason I can no longer export these very same tables. The exported text files have missing records. I have tried creating new versions of the tables using Make Table queries. I have tried closing Access and restarting it. I've tried rebooting my computer. I've tried to export the tables to Excel and then saving them to text or CVS format. They are missing records when they go to Excel. This has never happened before. My files are not too big (less than 20,000 records). They are not complex.
Has anyone else had this problem? Is it caused by a Windows 10 update? I've had other issues with Windows 10 (audio problems, Bluetooth and Wifi problems mostly) but no noticeable interference with other software.
2 Replies
You should use FoxPro as well.
YOu can try to visit https://support.microsoft.com/en-us/office/export-data-to-excel-64e974e6-ae43-4301-a53e-20463655b1a9 to see on how to export data to excel.

You can visit https://support.microsoft.com/en-us/office/export-a-database-object-to-another-access-database-4e2cd... to see on how to Export a database object to another Access database.