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 |
|
viking88
Starting Member
2 Posts |
 Posted - 2008-10-11 : 19:49:41
|
| You have to excuse me if this question is very easy, but I am just learning SQL. How can I combine 5 tabs of an excel spreadsheet into one table in SQL?All the tabs have the same amount of rows, but the number of columns are to large to fit in excel so I currently use 5 tabs, which as you can imagine can be cumbersome to navigate.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
viking88
Starting Member
2 Posts |
Posted - 2008-10-13 : 09:01:29
|
| Thanks for the info, but I beleive that article will import each tab into its own table. I am looking to combine all the tabs into one table. Is that possible? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-13 : 09:05:44
|
You can use SSIS for this.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Combine Tables