John R. Durant's has a great blog post about accessing SQL Azure data via Microsoft Excel 2010 on the MSDN blogs. Read it here.