Importing data from flat files (or some about other sources)

If you are faced with the task to import data from textfiles, including some best practices and life hacks around moving data from different sources (primarily files) and databases.