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 |
|
shafiq
Starting Member
3 Posts |
 Posted - 2011-05-13 : 07:02:24
|
| Hello All,On daily basis, 10 excel files get stored in a folder (all files contains same format). I want to upload data of these files to SQL Server through VBA. I know this can be done by openrowset or openquery of sql server BUT the excel file contains one vba code which does calculations and bring data in a desired table format which need to be uploaded to sql server.First plan, some way trigger this excel vba code from sql server - this would be great but don't know how to run excel vba code from sql server.Second plan, run vba code from excel file itself. Then upload result data to sql server through vba only ---need vba code for this.I would greatly appreciate all your advice and help. Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Import all Excel files data to MS SQL Server