I've got a .mdf which I have to import into MS Access. I've read that .mdf is really a Sql Server format so Access wont recognize it. But can there be a way I'm able to obtain the database produced in MS Access. I'm using Access 2003 and Sql Server 2005

Why don't you right click on the database in SQL Management Studio, click export after which specify the needed parameter?

I simply checked. Works during my installing of SQL Server 2008.

You can produce a new Access database and import the tables in the mdf file in it. You haven't pointed out the version of Access or SQL server therefore it is hard to become more specific.

Alternatively, if you can get an SQL Server, you are able to export the database being an Access .mdb.