|
| | | Forum Newbie
Group: Forum Members
Last Login: 1/29/2009 2:19:43 PM
Posts: 1, Visits: 1 |
| Hello...... I am working on SQL Server 2000. I have a database that has almost 150 tables. I need to develop a report in excel. For this purpose i need to fetch data from my database and display the same in excel.
After doing this i need to ensure that no one can edit the data that i have fetched. So somehow i need to lock the grid of the excel sheet in which i have displayed the report result. Cant do this........What to do?
-Krishi |
| |
| | | Forum God
Group: Forum Members
Last Login: 7/15/2011 3:57:36 PM
Posts: 371, Visits: 208 |
| Are you wanting to do this from Excel, SQL Server or VS? It's been quite a few years, but at one time I created a template that was linked to SQL Server. When opened(I had saved it with password protection) the sheets would populate with the data, formatted just as I wanted.
 |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 11/10/2010 2:18:17 PM
Posts: 2, Visits: 2 |
| [quote]Krishal Rajput (1/29/2009)
Hello...... I am working on SQL Server 2000. I have a database that has almost 150 tables. I need to develop a report in excel. For this purpose i need to fetch data from my database and display the same in excel.
After doing this i need to ensure that no one can edit the data that i have fetched. So somehow i need to lock the grid of the excel sheet in which i have displayed the report result. Cant do this........What to do?[/quote]
My father had an unpleasant issue with excel document. I advised him a tool, which to my surprise aided him quickly. Above it he thanked me a lot and I believe that such tool might be curious for solving similar propositions - how to recovery corrupted Excel file.
|
| |
|
|