convert mdf to mdb

hi all,

I'm using visual web developer and created a project with a mdf data file. how can I convert this file to MS ACCESS mdb file?

Thanks

Normally migration proceeds the other way!

Open your SQL Server management tool, select the database, go tasks, export and on the output select a pre-existing access database.

|||

I just installed Visual Web Developer and SQL Server 2005 Express Edition. Seems cannot find the tool you mentioned..

If programatically convert it I'm concerning some reserved words problem like "Value" in SQL server is ok while ion ACCESS is a reserved word..

And DateTime in SQL is one field while in ACCESS is in 2 fields..

|||

Hi stardust25,

TATWORTH :

Normally migration proceeds the other way!

Open your SQL Server management tool, select the database, go tasks, export and on the output select a pre-existing access database.

The solution TATWORTH has suggested you should work on SQL Server 2005. But since you haveExpression Edition installed, things are a little different.Based on my understanding, SQL Express doesnot have DTS/SSIS shipped with. We can only useBCP, Bulk Insert, Openrowset, Code..etc to do export/export (based on the datatype you want to deal with). You can take a look at this thread I answered recentlyhttp://forums.asp.net/t/1139369.aspx, I hope it can help you better understand the converstion process.thanks