October 7th, 2009, 04:24 AM
Generate SQL Script from MDB file
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
October 12th, 2009, 07:34 AM
try using sql data modeler from oracle
February 19th, 2010, 04:45 AM
I recommend a very simple yet useful tool: MDBScript,
it allows you to easily generate a .sql file for your .mdb file.
March 5th, 2010, 12:22 PM
This is DEFINITELY the easiest way. Microsoft SQL Server Database Publishing Wizard.
Discontent is the first necessity of progress. - Edison