Importing Data from Text File
There is an Excel file that teaches how to perform the Importing Data from Text File operation.
Excel Template for Importing Data From Text File
This workbook reads external text files and imports data into a 33-row worksheet using VBA.
Hope it is useful.