how to aggregate 3 txt files

[atai]

Hello,

I have a problem on my Access VBA program.
I have a function that create a txt file that need to be imported in a different system
My VBA code use 3 differents Access tables with different structure.
One for the header, one for the rows and one for the footer.
these 3 different tables are then exported on 3 txt files.
No problem until this, but when I try to aggregate these 3 files I have a problem.
I use a batch file that copy the 3 files in one but at the end of the file created there is a strange character created that create an error when I run the import program that load the file created.
Do you know other way to aggregate more files txt in one maybe using VBA?


Many thanks

[pbaldy]

It might help to see your code. Is there a reason you don't just create a single file from the function? Perhaps a UNION query is another alternative, joining the header, detail, and footer?

[orange]

Please tell us more about your use of "aggregate".

Is it A.txt + B.txt + C.txt ==>Final.txt?

Perhaps you could provide a sample (mock up) that shows the issue.

[atai]

This is the batch file
cd\venistar\v9_std_imp\pre-txt-in
copy *.txt c:\venistar\v9_std_imp\txt-in\po.txt

it's very simple, it copy all the folder pre-txt-in on the file po.txt
I run it with shell comand on my VBA

and this is the result
H;14;002680pre;002680;001;001;0;001;;11112019;;;14
I;14;8719852222981;1; 10.8;;
I;14;8719852222929;2; 10.8;;
I;14;8719852222752;2; 10.8;;
I;14;8719852222394;1; 10.8;;
S;14;pre nov-dic + coll feb-mar;10%;Ri.Ba. 60/90/120 gg f.m. dec;;;

May I use union query even if the 3 tables have different number of fields?

P.S.: after sent the post I realize that the strange character is a a carriage return

[pbaldy]

I meant the code that creates the text files. Yes, you can use a UNION query, you just have to add placeholders for fields that don't exist, like this where Table2 doesn't have Field2:

SELECT Field1, Field2, Field3
FROM Table1
UNION ALL
SELECT Field1, Null, Field3
FROM Table2

You could anything there, not just Null: 0, "", "N/A", etc.