SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Wed, 20 Jun 2012 01:30:48 +0000 Indexed on 2012/06/20 3:19 UTC
Read the original article Hit count: 576

Importing data into database is one of the most important tasks. I often receive questions regarding what is the quickest way to insert CSV data or how to import CSV Data into SQL Server Table. Honestly the process is very simple and the script is even simpler. In today’s SQL in Sixty Seconds Video we will learn how quickly we can insert CSV data into SQL Server.

The steps to import CSV are very simple.

  • Create Table
  • Use Bulk Insert to import the data
  • Verify the data
Done! Absolutely it is that simple.

More on Importing CSV Data:

I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.

If we like your idea we promise to share with you educational material.

Reference: Pinal Dave (http://blog.sqlauthority.com)

Filed under: Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology, Video

© SQL Authority or respective owner

Related posts about database

Related posts about Pinal Dave