ZURINET
asked on
Access to SQL Database from Excel
Hi all
I have a data stored in Microsoft sql 2005 database.. and 2008 version as well
The sql system is in a secured zone.
I have a Microsoft IIS Web server located in the same network as the sql DBs
I have a local computer desktop Windows 7 Enterprise Edition in a diffrent segment/network.
I have an Microsoft Excel version 2010 Application installed in the Desktop
Deskop Windows can access a shared folder in the same network as the DB via a single shared folder.
Desktop Windows can access the webserver via an open http://web link outside the firewall
What is the best and secured way to access the DB data stored in MSSSQL DB via Excel.. 2010 Application.
Thanks in Advance for your inputs.
Regards
ZH
I have a data stored in Microsoft sql 2005 database.. and 2008 version as well
The sql system is in a secured zone.
I have a Microsoft IIS Web server located in the same network as the sql DBs
I have a local computer desktop Windows 7 Enterprise Edition in a diffrent segment/network.
I have an Microsoft Excel version 2010 Application installed in the Desktop
Deskop Windows can access a shared folder in the same network as the DB via a single shared folder.
Desktop Windows can access the webserver via an open http://web link outside the firewall
What is the best and secured way to access the DB data stored in MSSSQL DB via Excel.. 2010 Application.
Thanks in Advance for your inputs.
Regards
ZH
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Had a work around
ASKER
Thanks for your reply
But some how you did not understand my question..
I am working on a solution..
Where by I periodically export the needed data as csv. file to the local folder
Then I manually Import the the csv. file into excel