Home » questions » Is there a way to get the sql code from MS Access to re-create a database that has been created in a

Is there a way to get the sql code from MS Access to re-create a database that has been created in a

3
2006-08-01 13:54:27, Category: Programming & Design
I have a database that i have created in microsoft Access and would like to get the text file for creating the tables, fields and data types, without having to code the sql myself.

Answers

  1. The Musafir

    On 2006-08-01 14:00:08


    it seems that there is no easy solution to do that i;'ve attached a newsgroup query thread that might help in way to get basic info out

  2. NC

    On 2006-08-01 14:13:12


    You could use Access2MySQL: http://www.data-conversions.net/products.php?prod_num=1 With this product, you can export your database structure and/or data into an SQL dump. You may have to edit the dump to remove some of the MySQL-specific code or put in some Access-specific code...

  3. delfin2k6

    On 2006-08-01 13:59:48


    yes http://support.microsoft.com/kb/237980/en-us