Forum Discussion
Juan_Palma
Nov 23, 2023Copper Contributor
remove line break when exporting to txt file
I am working with access 2016, I have created a report with a single line and 4100 characters/columns. The file in the report is correct, if I copy the report data and paste it in a txt, the program...
Tom_van_Stiphout
Nov 23, 2023Iron Contributor
Presumably the report is based on a table, and that table has a Long Text field with 4100 characters. Is that correct?
If so, you can use DoCmd.TransferText to export directly from the table. No report needed or wanted.
If so, you can use DoCmd.TransferText to export directly from the table. No report needed or wanted.
Juan_Palma
Nov 25, 2023Copper Contributor
thank you for your reply
could you tell me how to write the code of a table called table1 and the field where it is stored is called document.
I would appreciate it very much
could you tell me how to write the code of a table called table1 and the field where it is stored is called document.
I would appreciate it very much