Hi,
Is it possible to connecting to SQL Server using Excel Online?
Technology Tips and News
Hi,
Is it possible to connecting to SQL Server using Excel Online?
What is 'Excel Online'? Please see this link for several ways to use Excel & SQL Server together.
http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Introduction
WOW!! That's hellza cool!!! As I know, VBA doesn't work (AT ALL) with HTML, or any kind of online technologies.
Good luck with your endeavors.
>>> I already know how to connect desktop version of Excel to SQL Server. I could not find documentation on connecting to SQL Server using Excel Online.
Accrording to my search, you could not connect to SQL Server using Excel Online.
This issue is by design, so I suggest that you could submit feedback to Office.
https://support2.microsoft.com/common/survey.aspx?scid=sw;en-us;2222&altStyle=MFE&renderOption=OverrideDefault&showpage=1&fr=1&nofrbrand=1
Hi ihaveanazurequestion,
It's depending on how your environment is configured, some kinds of data connections are supported for workbooks displayed in a browser window, which enables you to refresh data. I suggest you refer to this article about refreshing data in a workbook in a browser window.
You also need to refer to this article about the difference between using a workbook in the browser and in Excel:
Hope it's helpful.
Regards,
Emi Zhang
TechNet Community Su