Show Posts
1
General Board / Exporting data structure to MS Access
« 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
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