Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 How to import data from an excel document

Author  Topic 

jbon
Starting Member

20 Posts

Posted - 2008-02-25 : 07:31:07
Hi, I want to import data into my sql server 2005 express database from a excel document. Roughly described I have all columns/data in a excel sheet that I will import to a table with same columns in my sql database. How do I do this in the best way because I'm sure this finctionality/possibility must be available?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-25 : 07:34:44
You can use bcp utility or Bulk Insert command to do this.

Also, check this: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82403

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-02-25 : 08:40:51
Also refer
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -