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 |
|
kohlhaas77
Starting Member
25 Posts |
 Posted - 2008-09-04 : 10:08:33
|
| I have 2 Excel files which are 50k and 51k records in length, and I want to combine the 2 files into 1 in SQL. How can I do this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 10:11:28
|
| Using export import wizard export data from both files to a sql table. I assume both files are of same structure (same columns). |
 |
|
|
kohlhaas77
Starting Member
25 Posts |
Posted - 2008-09-04 : 10:12:59
|
| Won't the second file overlay the first file?Is there not some syntax you can use to combine the tables?Yes, the format and everything is identical. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-04 : 10:15:40
|
| Use Union all task in SSIS package to Oledb destination. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 10:19:08
|
quote:
Originally posted by kohlhaas77
Won't the second file overlay the first file?Is there not some syntax you can use to combine the tables?Yes, the format and everything is identical.
didnt get that. i have asked you to transfer them to same table. didnt get what you mean by overlay? |
|
|
|
kohlhaas77
Starting Member
25 Posts |
Posted - 2008-09-04 : 10:41:02
|
| visakh16...that worked great! Thank you!Dan Kohlhaas |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 10:43:12
|
quote:
Originally posted by kohlhaas77
visakh16...that worked great! Thank you!Dan Kohlhaas
you're welcome  |
|
|
|
|
|
|
Merging 2 files