SQL Server 2008 Essential Training: How To Import CSV Files


show more Importing CSV files into SQL Server provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

Importing CSV files into SQL Server

If the data that you want to import is in comma separated values or indeed in anything that's just a regular text delimited file-- in fact here I've got to some very straightforward values, very similar to the last time, but they are separated with the vertical bar. I can also bring this into SQL Server although the way of doing it does have quite a few different options than doing it with Excel. So I'm going to go ahead and open up my Import and Export Data Wizard. I'm going to use the 32-bit one.

The source I'm going to pick here is Flat File Source. And when I select that, not surprisingly it's going to ask me to browse to that file, which is currently saved as a CSV on my desktop. And once I do that we have a very different screen for determining what that data is. If I click on the Columns section on the left, it will take a look and think yes, this column delimiter seems to be a vertical bar, and if you select that, this is what the date is going to look ...

Importing CSV files into SQL Server
Video duration: 5m 27s 6h 54m Beginner

Viewers:

Importing CSV files into SQL Server provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...