How can I import a delimited text file into a SQL Sever table?
Welcome to the world of BCP. Included with SQL Server, the Bulk Copy Program will import or export text files fast and efficiently. It allows you to specify the layout of the file by using a format file. The “Books Online” has a chapter that will walk you through the details.