You can open the text file with Excel, so that you get the "Text Import Wizard" that lets you specify how the columns are set up, whether fixed width or delimited by some character.
Then on the 3rd screen of the wizard, after your columns are divided, you can specify a data type for each...