multiple text files to one excel workbook

[alex75]

Hi,

I know this question has been asked and answered many times and I have read many posts in this subject,

but none of the previous posts really were able to help me. so, here's my problem:

I need to be able to ready multiple text files and save the content of those text files into a new (text) file and then paste that new text file into a new worksheet on an excel template.

here's what I have done so far, I am able to read the 3 text file and concatenate all 3 file into a new text file but when I transfer that to excel, it only shows one file being pasted into the new worksheet of excel file.

alternatively, dumping each of those text files into a new worksheet or multiple worksheets would be good too, if we don't concatonate the text files first.

I am hoping that somebody can show me the way.

Thanks all.

[Gregory]

I've never used Append Table to Report. Try using the Excel specific one: Excel Easy Table.vi

[alex75]

hi, I tried your suggestion, and that didn't work either.

I need all 3 text files in the excel worksheet, but this program only transfers one of the text files (the last one ) to excel; so it overwrites the provious files that it wrote.

any other suggestion ?

[Gregory · Accepted solution]

Yes, make the "Start" cell different each iteration. You can use the "next cell bottom left" if you want your data vertically stacked, or "next cell top right" to get it horizontally stacked.

[alex75]

Awesome!... It works

with much Thanks,