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-03 : 20:02:47
|
| Hello everyone,I am a new to SQL Server programming. My query is regarding how to run MS Excel macro/vba from MS SQL Server 2008. I am moving to MS SQL Server 2008 from MS Access DB due to contents limitation of MS Access. Previously, Macro available in MS Excel was run from MS Access vba automatically to upload data in MS Access. Now, I want same calculated data to be moved to SQL Server but don't know how to trigger it. Is it possible to activate/run MS Excel code from MS SQL Server or some code to open this MS Excel from MS SQL Server? I searched for this query but not found in this forum. I would greatly appreciate for all your guidance. Thanks. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-05-03 : 21:05:25
|
i don't think it is possible to do that. Can you give some example on the calculated data that you required in SQL Server ? Maybe we can advice you the way to do it in SQL Server
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-04 : 00:07:49
|
| You absolutely do not want to run an Excel macro from SQL Server. If you're trying to upload data from an Excel workbook, either rewrite the macro to upload to SQL Server when it's opened, or use SSIS. |
|
|
|
|
|
|
Run MS Excel macro from MS SQL Server 2008