#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    5
    Rep Power
    0

    Generate SQL Script from MDB file


    Hello

    I'm just wondering how can I generate SQL Script (like as Create TABLE(....) Insert (....)) from a MDB file?

    I searched all MSAccess 2007 but didn't find anything. Should I use any other softwares?

    Be happy if anybody can tell me a free software or a solution

    Cheers
  2. #2
  3. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    119
    try using sql data modeler from oracle
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2010
    Posts
    1
    Rep Power
    0

    Lightbulb MDBScript


    I recommend a very simple yet useful tool: MDBScript,
    it allows you to easily generate a .sql file for your .mdb file.
  6. #4
  7. Business Analyst
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Mar 2004
    Location
    The 'Ville
    Posts
    1,087
    Rep Power
    22
    This is DEFINITELY the easiest way. Microsoft SQL Server Database Publishing Wizard.

    http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
    Discontent is the first necessity of progress. - Edison

IMN logo majestic logo threadwatch logo seochat tools logo