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 |
|
cgkitab
Starting Member
6 Posts |
 Posted - 2008-06-05 : 20:10:21
|
| I would like to know how I can pass some excel rows of data back to a table in SQL Server.The rows would look like:Account Number Account Description Period1 Period2 Period3 etc.62000-350-810- Salaries 2545 2000 5000There is already a table set up in SQL to take this record.Was hoping to create a mini application that takes this data from SQL Server 2000, change numbers in Excle and send it back as an update or delete row and append.Any ideas?Cheers Allan |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-05 : 20:13:26
|
| There are three options:1. BULK INSERT (T-SQL command)2. DTS (Data Transformation Services, designer is built into Enterprise Manager)3. bcp (command line utility)Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Passing Data back from Excel to a table in SQL Ser