IMPORT & FORMAT OF TEXT FILES

HOW DO I AUTOMATE TEXT FILE IMPORTING AND FORMATTING IN MS-EXCEL OR MS-ACCESS. I TEND TO GET TIRED MANUALLY DROPPING OR PROPERLY SPACING DATA.