Take a look at SSMA, it is not a scripting solution but makes it very easy to migrate:
Microsoft SQL Server Migration Assistant for Access v5.2
"SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server.
SSMA for Access v5.2 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure."
I have used this in the past to move Access into SQL and it works very well. In some cases you may find that you need to rename tables / columns if they violate MSSQL naming rules - if so then a great tool is Find & Replace from rickworld.com which costs about $40 USD.