Return
-
Title
Getting error 'Object doesn't support this property or method' when importing from Excel -
Description
Getting error 'Object doesn't support this property or method' when importing from Excel. On previously exported to Excel from new data model. First created 4 empty entities and then in Excel populated the Table name, Caption, Name, Data Type, Data Type Parm 1 Mandatory, and Description fields. The error happens is it imports the first field name as Bigint and no other metadata. Each time, another attribute gets created, but again without metadata.
-
Resolution
- Create a Physical Data Model with the same 4 blank tables.- Export to Excel- Then add attributes and some metadata- Imported back into the PDM from the Excel file.