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.
| Author |
Topic |
|
jsc0624
Starting Member
13 Posts |
 Posted - 2007-04-25 : 03:15:43
|
| Hi everyone got a problem here!I have an existing data in excel and it is more than 10,000 cells that I need to import to my new SQL Database. How can I transfer those records easily without using INSERT commands in SQL? Because I'm afraid it's too hard to do.===============JSC0624=============== |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-25 : 03:19:18
|
You can use DTS to do it. Refer to Books On line for more information or visit http://www.sqldts.com/
KH |
 |
|
|
jsc0624
Starting Member
13 Posts |
Posted - 2007-04-25 : 04:27:22
|
| It's too hard to follow the instructions there. I'm only new in SQL and I don't have any idea on how to use sqlbulkcopy? Is this a language or an application? Where can I find it in SQL Query Analyzer? How to run it if this is a code? Where can I create this code, in excel? VB? ASP? Please help I need to transfer more than 10,000 records. Thanks in advance.===============JSC0624=============== |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-25 : 04:37:37
|
there is a DTS wizard to do this.1. Run Enterprise Manager2. right click on the database and select all tasks - IMPORT DATAfollow instruction on screen
KH |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-04-25 : 06:49:56
|
| Press the F1 key and Read it up in Books onlinedo a search for DTS Import/Export Wizard andDTS Transformations |
|
|
|
|
|
|
Import Excel Data in SQL Server Database