How to import .mdb files into SQL Server 2008?

Question

Assuming it can be done (as I've been told): How do I import .mdb (MS Access / OleDb) files (specifically Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)?

Bob Lewiston · Answer

Well I just tried it. As soon as I hit the down-arrow to make a selection from the database drop-down menu (default selection:  ) the system crashed. I wonder why?

Bob Lewiston · Answer

Mahesh Chand: Never mind I found it.

Bob Lewiston · Answer

Mahesh Chand: Do you mean that the Import/Export option is in SQL Server 2008 Management Studio?

Mahesh Chand · Answer

In SQL Server there is an option Import/Export and if you select Import option follow wizard instructions. It will ask you what database to import from etc. Good luck.

How to import ".mdb" files into SQL Server 2008?