SQL Server DB to Access DB RRS feed

  • Question

  • Is there any way to transform a sql server DB to and MS Access DB without doing it manually? I'm doing .Net program for personal use but someone wants a copy. I dont want them to have to install SQL server to run the program. Since most windows programs have MS Access, I think it would be more portable to do a MS Access DB.
    Any suggestions?

    Wednesday, July 12, 2006 11:10 AM

All replies

  • what you can do is to create a dts that do this transfer and then ask your programers to call a PROC that will call a job that will execute dtsrun.


    Wednesday, July 12, 2006 11:44 AM
  • I am the only dba, and programmer. its a personal project.
    I just want to the steps to transform a sql server db into an Access db
    Wednesday, July 12, 2006 11:49 AM