Windows SharePoint Services 3.0
Does anyone know how to mass delete records in WSS 3.0 ?
For example : we have one tab which contains over 3,000 records if we want to delete record ID from 1 to 2,000. Is there anyway we can do it quickly? (Like in Excel you can highlight row 1 to 2000 and then delete them all with one click)
For example : we have one tab which contains over 3,000 records if we want to delete record ID from 1 to 2,000. Is there anyway we can do it quickly? (Like in Excel you can highlight row 1 to 2000 and then delete them all with one click)
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.
Try using Quest tool : Sharepoint server admin and you can do all this like you would in windows explorer
ASKER
we have Office 2007 Enterprise and only show standard view in our Sharepoint with error message at the bottom "A datasheet component that is compatible with Windows SharePoint Services is not installed". I checked Microsoft website it said "Support for Windows SharePoint Services list data is available only in Microsoft Office 2003 Professional editions"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just can't create dataview in Sharepoint Services 3.0 with Office 2007 Ent.
Check our environment, all datasheet components have been installed, ActiveX control and support are enabled. Just like Microsoft website - "Support for Windows SharePoint Services list data is available only in Microsoft Office 2003 Professional editions" - Is it true?
we'd like to have dataview solution - Coding will be considered as a last resort.
Check our environment, all datasheet components have been installed, ActiveX control and support are enabled. Just like Microsoft website - "Support for Windows SharePoint Services list data is available only in Microsoft Office 2003 Professional editions" - Is it true?
we'd like to have dataview solution - Coding will be considered as a last resort.
you can make a registry edit to gain access to datasheet view
http://weblogs.asp.net/felipeferreira/archive/2009/07/30/sharepoint-activex-error-when-trying-to-view-list-in-datasheet-view.aspx
http://weblogs.asp.net/felipeferreira/archive/2009/07/30/sharepoint-activex-error-when-trying-to-view-list-in-datasheet-view.aspx
ASKER
I only can have dataview on the WSS server but can't have it from my own PC workstation - it is enough for us.
Thank you for all experts comments especially sabby447
Thank you for all experts comments especially sabby447