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 |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2012-08-02 : 11:43:56
|
| Hi,I have about 100 .xls files which I need to dump into a one Table SQL server 2008. They all have the same structure.I know this is can be done using the BID, however, I would like some directions or a process of how to do it.Steps of the process would be very appreciated.Thanks,--------------------------Get rich or die trying-------------------------- |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-03 : 12:26:49
|
| visakh16,Thanks, for the blog, it was helpful. but I couldn't complete this task until i converted all my Excel files into .CSVs.Somehow the excel files is causing so many warning because of the data conversion. I'm just curious if anybody have ever ran into a similar issue.issue:Import Excel data into a SQL Table (using SSIS) will cause data conversion warning and even trying to mapp all fields (Excel Vs SQLTABLE) to have all the same type will still cause the same error.Thx,--------------------------Get rich or die trying-------------------------- |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-03 : 15:02:02
|
quote:
Originally posted by xhostx
visakh16,Thanks, for the blog, it was helpful. but I couldn't complete this task until i converted all my Excel files into .CSVs.Somehow the excel files is causing so many warning because of the data conversion. I'm just curious if anybody have ever ran into a similar issue.issue:Import Excel data into a SQL Table (using SSIS) will cause data conversion warning and even trying to mapp all fields (Excel Vs SQLTABLE) to have all the same type will still cause the same error.Thx,--------------------------Get rich or die trying--------------------------
you just need to add a derived column task in between to convert unicode data(thats how text data within excel is interpreted by system) to non unicode before you dump it to table to avoid warnings------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-03 : 15:16:23
|
| Thanks a lot for your help.--------------------------Get rich or die trying-------------------------- |
|
|
|
|
|
|
|
|
Import Multiple Excel Files