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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2009-08-05 : 13:53:15
|
| Gurus,one excel contains 5 different sheets, each sheet contains 10 col when we load all these sheets into one table in db, we need to add one extra common col for all those 5 sheets data.Suppose the name of the 5 sheets is t1,t2,t3,t4 and t5,when we load this data into db, in that col we need to menction, which data is comming from which sheet (like from t1 or t2 or ....)Regards |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-05 : 14:49:42
|
If I say I am loading data from excel into a table, would you know the way I do it?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Importing Data