Can't export a table from access #3

%3CLINGO-SUB%20id%3D%22lingo-sub-1866620%22%20slang%3D%22en-US%22%3ECan't%20export%20a%20table%20from%20access%20%233%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1866620%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20export%20a%20big%20table%20(%26gt%3B2%2C6%20million%20record)%20from%20Access.%20I%20recieve%20an%20error%20message%3A%3C%2FP%3E%3CP%3EThe%20Mircosoft%20Database%20Engine%20can't%20find%20the%20object%20'xxxxxx%23txt'.%20The%20point%20in%20the%20extension%20is%20replaced%20by%20a%20'%23'.%3C%2FP%3E%3CP%3EWhat's%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(Try%20%233)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1866620%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1868396%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20export%20a%20table%20from%20access%20%233%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1868396%22%20slang%3D%22en-US%22%3EHow%20are%20you%20trying%20to%20export%20the%20data%20exactly%3F%20Can%20you%20give%20us%20repo%20steps%20please.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1868506%22%20slang%3D%22en-US%22%3ERE%3A%20Can't%20export%20a%20table%20from%20access%20%233%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1868506%22%20slang%3D%22en-US%22%3EHello%20Daniel%2C%20I%20tried%20several%20thing.%20First%2C%20the%20table%20is%20large%2C%20%26gt%3B%202.6%20million%20records.%20I%20choose%20for%20export%20%26gt%3B%20textfile%20and%20than%20I%20take%20the%20standard%20location%20on%20my%20local%20disc%2C%20and%20the%20standard%20name%20that%20ends%20with%20.%20txt.%20Than%20I%20choose%20for%20separated%20fields%20(%3B)%2C%20and%20fieldnames%20in%20the%20first%20row.%20Than%20I%20say%20'next'%20and%20%22voltooien%22%20(Dutch%20for%20'complete'%3F%20OK%3F).%20After%20that%2C%20the%20error%20message%20occurs.%20In%20that%2C%20the%20name%20of%20the%20file%20ends%20with%20%23txt%20instead%20of%20%23.txt.%20'The%20Database-engine%20can't%20find%20the%20object'%2C%20it%20sais.%3C%2FLINGO-BODY%3E
New Contributor

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)

3 Replies
How are you trying to export the data exactly? Can you give us repo steps please.
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.

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