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 |
|
akanodia98
Starting Member
6 Posts |
 Posted - 2006-05-11 : 16:12:33
|
| Hello,I am new to SQL server world.I have a task to transfer data from excel sheet(s) to sql server.I read I could do that using DTS.But the problem is I have more than 1 excel files and in my table I need to get records from both the files with out duplication the data.ex: one excel sheet conatins field 1,2,3 second sheet contains field 1,4,5,6 (now I should put data in the sql table as 1,2,3,4,5,6)I will have to continue to do add data to this table as I get new excel sheets (the fields will remain same).Can somebody help me with this? If you can also give me some references for this it will be very helpful.Thanks a lot in advanceNicky |
|
|
sshelper
Posting Yak Master
216 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-12 : 04:56:12
|
| http://sqlteam.com/forums/topic.asp?TOPIC_ID=53720MadhivananFailing to plan is Planning to fail |
 |
|
|
akanodia98
Starting Member
6 Posts |
Posted - 2006-05-25 : 14:24:38
|
| thanks for all the helpNicky |
|
|
|
|
|
|
Excel to sql server data transfer