Importing Access 2007 Tables into SQL Server

Microsoft SQL Server 2005 offers the Import and Export Wizard to move data from one source to a destination. With the Import and Export wizard, you can access different types of data sources. These sources include other database formats such asMicrosoft Access, Microsoft SQL Server, flat files, Microsoft Excel or Oracle database.