Text files can be imported or just pasted into Excel. If you want to learn more about SQL statements and non-code coding, look at this blog:
"Excel doesn't have an easy way to append multiple text files into one worksheet through the user interface. From time to time I hear customers asking how to do this in an easy way. Do you have to use Access or VB code to solve this problem? No. There's a way to do it in Excel by using a simple SQL statement in the connection string."