Learn How to Do-It-Yourself!

Choose a Flat File Data Source to import

 
View original image
Choose a Flat File Data Source to import
Choose a Flat File Data Source to import into SQL Server 2005, and change the Format settings to correspond with your text file.

Related article
How to Import Delimited Text Files into a SQL Server 2005 database