From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Importing Excel files into SQL Server

Importing Excel files into SQL Server - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Importing Excel files into SQL Server

So I'm going to go ahead and take a straightforward Excel spreadsheet and import that into SQL Server. This is the spreadsheet that I have at the moment. It's a list of names, addresses, and zips and email, just some contact information. I can see that the first row does seem to contain the column names for this, so that might be useful in just a moment. But that's what I want. I just want it in my database, because it's way too easy to mess it up when it's an Excel. So I'm going to open up the SQL Server 2008 R2, Import and Export Data. I'll open up the 32-bit one, so it should be all I would need here. I'm going to click Next. Select that my data source is Microsoft Excel. It's going to ask me for the file path, which is just out here on my desktop. And it's going to ask me for the Excel version and I think it's 97-2003. If there is a problem with that it will probably tell me in just a moment. And I'll leave this checked. Yes the first row has column names. I'll click next. It's…

Contents