How to import text files into SQL Server Management Studio in 5 easy steps.

By Charles McDowell

Comptia Certified Linux Networking Professional.

Cisco Certified Networking Technician.

Microsoft Technology Associate Database Administration

View fullsize

“I choose a lazy person to do a hard job. Because a lazy person will find an easy way to do it.
”

— Bill Gates

1.       Right click Database and go to properties.

2.       Select import data, select flat file source and upload txt file. Make sure content is delimited.

3.       Go to column section under data source, make sure the columns and data look correct.

4.       Next choose the destination as sql server native client 11.0.

5.       After that select run immediately and hit finish.