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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-03-14 : 15:14:49
|
| I receive daily excel 2003 workbooks from my company's main customer to load into a sql server 2008 database r2 standard edition. Right now I am manually copying the data from the worksheet I need to work with and passing the data to entirely to new worksheet in a new workbook. My company says that I can not ask the user to change the way we receive the data from them. The current method is going to stay. I now want to be able to automate the process of obtaining the data from these workbooks. However I am having the following problems I need to work with and I am wondering if you have any suggestions how to to automate the following steps:1. There are lots of tabs in the workbook and I always need to go to worksheet in the middle of the workbook to obtain the nformation I am looking for. 2. There are hidden columns that I always have to unhide. 3. For your information, the worksheets are grouped together. However I do not need to ungroup the worksheets to obtain the data I need to work with. What way would you suggest I follow to accomplish this goal? Can you tell me and/or point me to a reference that will show me how to accomplish this goal?I think an SSIS package would solve this problem but I have no experience working with SSIS packages. Thus can you tell me what you would suggest? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-14 : 15:52:22
|
| you can use SSIS packages and automate sql agent jobs to call thembut some things to note are:-1. whether worksheet will have a consistent name always as we cant have ssis rely on position of sheet2. You've to write an excel macro for that3. no issue in keeping them as grouped------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2012-03-16 : 16:07:55
|
| Thanks! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-16 : 16:11:09
|
| welcome!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sql server working with excel