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.
2006-08-01 09:54:27 · 3 answers · asked by eap 2 in Computers & Internet ➔ Programming & Design
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
2006-08-01 10:00:08 · answer #1 · answered by The Musafir 2 · 0⤊ 0⤋
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...
2006-08-01 10:13:12 · answer #2 · answered by NC 7 · 0⤊ 0⤋
yes
http://support.microsoft.com/kb/237980/en-us
2006-08-01 09:59:48 · answer #3 · answered by Delfin 4 · 0⤊ 0⤋