Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: bo.grevy on April 04, 2006, 01:34:13 am

Title: Exporting data structure to MS Access
Post by: bo.grevy on April 04, 2006, 01:34:13 am
Hi!
I a trying to export my model to MS Access in order to make a template database (creating the tables with the correct columns).

I have tried export to xml (*.xsd), and then import the xml-file in MS Access in order to create the tables including the columns. That solution works very fine, but there is a problem: All columns defined with datatype "long" in EA is created with datatype "text" in MS Access.

Does anyone have a "work around" for this problem?

Kind regards,
Bo Grevy