Migrating Access Tables to SQL Server - Beginner

I'm working in an Acce开发者_如何学JAVAss 2007 database and need help migrating tables to SQL server. Is this possible to do having only purchased Access 2007 or do I need to download a separate program for SQL? When I try to create a new SQL database or open an existing one through Access, I'm getting a "CREATE DATABASE" or "CREATE TABLE" error and not sure what the issue is. Any advice would be greatly appreciated!

Take a look at the microsoft's SQL Server Migration Assistant 2005 for Access (v4.0) which supports access 97 - 2007

Yes, you need to install it. There is a free edition of SQL Server, called Sql server express. Database size limit is 4gb. If it suits you go for it. Also, i belive Access has migration tool built in.

Update: In Access 2007 - Database Tools -> Move Data -> Sql Server ( follow the wizard ).