How to import ddl database file to MS Access?
I have a logical model and a database generated from it. How can I export database from Rational rose and import it to MS Access? I managed to export database as *.ddl file.
Solution
This was answered, as well as can be done, in How can I import a database schema into MS Access 2003 from sql text file? The process is cumbersome, and does not lend itself well to automation.
A possible more practical solution is to use a command line tool and run the DDL as a script. See http://en.wikibooks.org/wiki/JET_Database/Manipulation_tools for a list of tools (unchecked).
The JetSQLConsole command line tool at SourceForce is current and can implement what you require.
- Access VBA MSHTML document with scripts loads slowly
- Populating subform fields from main form field
- Separate column value by space and dash
- Accent-insensitive query in MS Access 2013
- 1 Access Query to Multiple Excel Files Based on Field Value
- Ucase in Access report page header
- Auto scroll to bottom with a textbox
- Trying to use VBA in Access to force string to be a specific Length
- MS Access ADODB.Recordset Cannot Add adLongVarWChar field. Error 3001 Arguments are of Wrong Type
- How can I test and handle a #Func! error from within a query?
- Error on a recordset, but same SQL works elsewhere
- How to extract the schema of an Access (.mdb) database?
- Manipulating an Access database from Java without ODBC
- How to overlap microsoft access - report detail section layout to the previous one to avoid extra rows?
- What can trigger MS Access autoexec vba macro?
- Import recordset from Access to VBA ListBox
- Check if access table exists
- MS Access: There isn't enough memory to perform this operation (Reports)
- How to pass an array to a function in VBA?
- Getting "Too many parameters for command", when calling WinSCP command-line from VBA
- MS-ACCESS Difference between TempVars and TempVar
- Create a MS Access Pivot Query that returns rows even if there are null values
- Microsoft Access SQL is clipping a string when using INSERT to add a record
- Exporting a query result into a text file using vba-MS Access
- VBA referencing external module in .accdb database "tantrum"
- Is there a shorter way of appending information to an existing string?
- How can I automatically update the data in a record when I create a new record in a different table?
- ODBC driver for MS Access seems missing (Windows 64 bit)
- Access is multiplying my query count by 38.... why?
- VBA "does not equal" code not stepping through IF statement as expected