Forum Discussion

Bart_Vreeken's avatar
Bart_Vreeken
Copper Contributor
Nov 09, 2020

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 extension is replaced by a '#'.

What's wrong?

 

(Try #3)

access

3 Replies

Sort By
  • Bart_Vreeken's avatar
    Bart_Vreeken
    Copper Contributor
    Nov 09, 2020
    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_Vreeken's avatar
      Bart_Vreeken
      Copper Contributor
      Nov 12, 2020

      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 (?)

       

Resources