Converting txt Files

Question:
How can I import a delimited text file into a SQL Sever table?

Answer:
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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: