SharePoint 2010 Launch

It’s been announced! The SharePoint 2010 and Office 2010 launch will be May 12th 2010 and the RTM will be in April.

Removing SharePoint Survey Top Page Buttons

Tags

Sharepoint, survey

I got request to remove the top buttons in the sharepoint survey to avoid user click next without scroll down the page. Below is the Javascript to do it.

var x=document.getElementsByTagName("input");
for (var i=0;i<x.length;i++)
  {
  if (x.item(i).type=="button"&&x.item(i).id.indexOf("top")>0)
     {
	if(x.item(i).value=="Save" || x.item(i).value=="Next" || x.item(i).value=="Cancel")
	{
		x.item(i).style.display = "none"
	}
     };
  }

Excel “External table is not in the expected format.”

Tags

Excel 2007, OLEDB

If you are using “Microsoft.Jet.OLEDB.4.0” to query Excel 2007, you may get this error.
“External table is not in the expected format.” typically occurs when trying to use an Excel 2007 file with a connection string that uses: Microsoft.Jet.OLEDB.4.0 and Extended Properties=Excel 8.0

Using the following connection string seems to fix most problems.

public static string path = @"C:\src\RedirectApplication\RedirectApplication\301s.xlsx";
public static string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";