Data integration with Excel
General
Model data exchange using Bizzdesign Connect
Process of creating a data connection
About data mapping in Bizzdesign Connect
Elements for modeling connections
Controls for Connection objects and relationships
Excel connection
Structure of an Excel connection
Importing model data from an Excel workbook
Exporting model data to an Excel workbook
Limitations on naming Excel mappings for export
Using timed data in the Excel import and export
Creating relations using an Excel import
Import and export of Excel worksheets using an ADOdb connection
Mappings and relations
Mapping tables, metaobjects, and metarelations
Importing table column headings from Excel
Adding and deleting mapping table columns
Text to date and number to money conversion for Excel import
Adding metaobjects and metarelations via the Create pane or quick-create pop-up window
Linking multiple types to a metaobject or metarelation
Mapping metaobject or metarelation properties to a relation cross-reference table
Changing the order of properties in a metaobject or metarelation
Changing the property value of a metaobject or metarelation
Making imported tagged values non-persistent
Relocating the connectors of a metarelation