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 - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.