Can I import a Microsoft Access database into SQL Server?

Yes, right click on a database, select all tasks, data import. The ability to select an Access Datasource is one of the options.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

I'm sorry. Misunderstanding on my part.

I'm using Server Management Studio Express.

Right click on a database --> Tasks --> Import Data --> follow the on-screen wizard.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Actually the solution was using the upsizing wizard in Microsoft Access.

The database was exported directly to SQL Server.

Thanks for your help!