ms-accessrational-rose
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.
- Looking to get a string evaluated a second time so that I can change a single rule across independent queries
- SQL Server migrate new data into old schema
- Copy a ODBC-linked SQL-Table to an Access table with VBA
- Creating a Document Database using Microsoft Access
- Import CSV file and transpose to tabular table
- In MS Access using VBA: I want to transfer records with less than N^2 time complexity
- Microsoft Access SQL
- SqlCommand doesn't return result from the C# application (MS Access database)
- Access 2010 Forms VBA - Set Focus to Record on image click
- Expressing basic Access query criteria as regular expressions
- Where is acedao.dll?
- How to show the same field value from another entity attributes
- Convert Foxpro .dbf file to excel via ms access
- Opening table shows "Enter parameter value"
- Init Date variable with null value
- Button To Add Text and a new line
- Ms Access series numbering that resets monthly and yearly
- Recordset.Sort method not sorting
- How can I remove a link to an excel document from a previous 'DoCmd.TransferSpreadsheet acLink ..' command?
- MS Access Edge Browser Control to call a telephone number (W10)
- Creating a relationship with a calculated field
- how to count the number of records with ExecuteScalar if more than one then cannot insert into in the MS Access database on vb.net
- How to list DataMacro objects in an Access database?
- Inner join returning duplicate records access sql
- The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data
- How can I always round up decimal values to the nearest integer value?
- Word VBA insert multiple images and captions at bookmarked location in template document from Access
- Conversion from string to Date with PM is not valid in VB.Net
- Access change dates on other date fields based on date in first date field
- How do I force MS Access to retain its SQL formatting?