Forum Discussion
Bart_Vreeken
Nov 09, 2020Copper Contributor
Can't export a table from access #3
Hello community, I can't export a big table (>2,6 million record) from Access. I recieve an error message: The Mircosoft Database Engine can't find the object 'xxxxxx#txt'. The point in the exte...
Bart_Vreeken
Nov 09, 2020Copper Contributor
Hello Daniel, I tried several thing. First, the table is large, > 2.6 million records. I choose for export > textfile and than I take the standard location on my local disc, and the standard name that ends with . txt. Than I choose for separated fields (;), and fieldnames in the first row. Than I say 'next' and "voltooien" (Dutch for 'complete'? OK?). After that, the error message occurs. In that, the name of the file ends with #txt instead of #.txt. 'The Database-engine can't find the object', it sais.
- Bart_VreekenNov 12, 2020Copper Contributor
Any clues so far?
Exporting smaller tables to .txt goes well, so I think that the problem is in the size of the table (>2,6 million records). I'm using the Dutch version of Office (nl nl), maybe the problem is only in this version (?)