Import Excel into SQL Server

Question

In Access, I was able to easily import Excel spreadsheets into a table. But, I haven't yet found a way to do this in SQL Server. I've seen some posts on writing some sort of code involving Excel as an ADO object, but this seems to be way too cumbersome for something that was so easily done in an inferior product.

Is there no way to simply import the sheet without having to write code?

Thanx in advance!

Answer 1

Hi,

how about trying a Integration Services Connection Project in SQL Server Business Intelligence Development Studio as you can choose Excel as a data provider.

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer button if a post solves your problem!

Answer 2

Hi Adam,

Open management studio and select database where you want to import the data. Open context menu (right mouse click) and select Tasks/Import Data. This would open Import Data wizard where you would be able to select excel file as the source.

---

Thank you!

My blog: http://aboutsqlserver.com

Answer 3

Hi Adam,

Open management studio and select database where you want to import the data. Open context menu (right mouse click) and select Tasks/Import Data. This would open Import Data wizard where you would be able to select excel file as the source.

---

Thank you!

My blog: http://aboutsqlserver.com

Excellent!

I knew there had to be a way to do it cleanly without jumping through a bunch of hoops.

Answer 4

There are several ways to do this!

 

Click method:

http://msdn.microsoft.com/en-us/library/ms140052.aspx

 

Code method:

http://support.microsoft.com/kb/321686