Can an SQL database be exported into Access database format?

[Heavenly]

I have been working on VB 2005 and SQL express lately. I wondered if it is possible to export any database created with these application into Access database format.

Would I have any problem in the exporting, would I loose any data? Does anyone have any idea where to get information on how to do this?

Thanks for all your answers.

 

[suddenelfilio]

Yes this is possible, but it's not really .Net related. You should use DTS in sql server 2000 and I believe it's called integration Services in sql server 2005. With these services you can export and import almost every type of data into and to any type of data. It's realy handy. We are currently using DTS to centralize over 3.000.000 records from over 100 files all excel, access some cvs or plain text. we are putting all of them in a sql server to prepare for an export to DB2. ;-)