Text file

[Az2025]

Hello everyone,
Help please, I am generating a text file (Export specification, ). In the table I export, the field is text type, I have tried with long text also.

Regards,

[ranman256]

is there a question?
does it not make the text file using: docmd.Transfertext....

[Az2025]

Thank you ranman256,

I execute this instruction:
DoCmd.TransferText acExportFixed, "BNL", "tblBcoL", "c:\Bcl\BANL.TXT", False

Regards,

[ssanfu]

Still no question or what the problem is you are having.

What program did you use to open the text file? If I use Notepad++, I can see the CR LF symbols if I set the view to "Show All Characters".

[Az2025]

Dear ssanfu,
Thanh you!
My apologies, I use notepad. I have to export a table of 10 fields in a database (ms access 2016 64 bits), to a fixed text file, through an "export specification". The table has text and numeric fields and each line of records in the resulting text file has a length of 103. The last text field in the source table has a width of 32, in the resulting text file I get the error in the image. Well I don't know what I am doing wrong.

Regards,

[ssanfu]

I've tried to replicate your TransferText command; the text file is created butI can't get Notepad to display the text file like you posted.
Maybe post your dB?

[Az2025]

Hello everyone,
My apologies for the delay, there were connectivity limitations. Thanks for the attention to my request for help, especially to ssanfu, I have already solved, I had modified an old export specification, and it was the one I intended to use. I deleted it and created a new one and everything is fine. This topic is closed.

Regards,

[Micron]

No, the topic is still open. Please mark it as solved so that others don't waste time reading through it all just to find out it's solved. Thread tools button at the top.