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 have Expression Edition installed, things are a little different.Based on my understanding, SQL Express doesnot have DTS/SSIS shipped with. We can only use BCP, 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 recently http://forums.asp.net/t/1139369.aspx, I hope it can help you better understand the converstion process.thanks