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 |
|
SamuelT
Starting Member
6 Posts |
 Posted - 2007-07-26 : 05:02:58
|
| Hi all,I'm trying to import around 4000 rows of data into SQL from an Excel spreadsheet. I thought I might be able to simply copy and paste into SQL Server (Tables > Right click on table > Open Table), but when I try this only one value is pasted in. There's only around eight columns and I've been trying to do each seperately but to no avail.Can anyone suggest a means importing this data (as a whole, or in , either through some simple copy and paste function, or through some code?TIA,SamuelT |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2007-07-26 : 05:17:06
|
| you can use DTS to Import Data from Excel sheet to SQL server Table.also go thru this link...http://support.microsoft.com/kb/319951 |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Pasting Multiple Rows