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.
- Moving Files in MSOffice Access 2010
- How to format a general date to a distinct month in a combobox dropdown list in Access VBA?
- Date/Time Format VBA Access Query
- Use SQL to combine multiple Crosstab query results into individual Bins (ranges)
- Referring to a subform as recommended produces an error
- Building <select> in Access form
- Method 'columns' of object '_Global' failed error - VBA Access
- how can i extract the form information from a .mdb file?
- Dlookup syntax with multiple criteria including "Like"
- MSCAL.OCX not working on MS Access 2010(64-bit) on Windows 10(64-bit)
- MS Access Listbox click will not register a listbox selection
- Access VBA: How do I make the VBA editor stop auto-filling values?
- VBA Replace “Start” attribute deletes text
- Search by specific date in Access database with VB.net
- Sum Time Field in Access
- What are the Pros and Cons of VBA Code vs Macros in MS Access?
- How to reduce ms access database file size(*.accdb) after deleting data in it (MS Office 2007)
- How do I open an old Microsoft Access adp file with invalid connection strings?
- I need to split a text column in Access that stores dates in MM/YYYY and MM/DD/YYYY format to remove the day format
- Query to Find Adjacent Records in Access 2016
- Access VBA create a new table in an email when the field changes
- Microsoft office Access `LIKE` VS `RegEx`
- What is wrong with the variable?
- Error in odbcConnectAccess2007("BD-Embalses.mdb"). R could not find the function "odbcConnectAccess2007" after installing and loading RODBC
- SQL Learner -- MS Access 2013 ON UPDATE CASCADE and ON DELETE CASCADE
- Why does Access-Vba stops even if AllowSpecialKeys is turned off?
- How to disable access security notice "A Potential security concern has been identified"
- How to speed up the tranfer of information between Excel and Access?
- Access VBA MSHTML document with scripts loads slowly
- Populating subform fields from main form field