Russell Sinclair announced from the Microsoft Access Team blog on 8/12/2010 that you can now Easily migrate Access data to SQL Azure with a new SQL Server Migration Assistant (SSMA) for Access:
A couple of months ago, we posted a blog entry on [the OakLeaf Systems Blog] about how to use Access 2010 with SQL Azure. At that time, the easiest way to migrate your Access data to SQL Azure was to first migrate the tables and data to a non-Azure SQL Server then to use SQL Server tools to migrate these items to a SQL Azure database.
Today, we are pleased to let you know that the SQL Server team has released a new version of the SQL Server Migration Assistant (SSMA) for Access that will allow you to migrate your data and schema directly from Access to SQL Azure, as well as SQL Server 2005, 2008 and 2008 R2. Just like with SQL Server, you can use your Access 2010 application as the front-end to your SQL Azure database.