Import CSV. Column containing more than 255 chars.

[ggandhi]

I am importing a CSV file into a Sparx Repository package to create nodes. I am selecting Import/Export > CSV Import/Export from the package Context (right-mouse) menu. I select my Specification 'CMDB_DISCOVERY_NODE', click on Action = Import, then on Run button.

If any CSV column contains data with more than 255 characters, I get the following message:
DAO.Field[3163]
This field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

My plan (to avoid this error message) is to write a JScript that performs the import and traps the error, allowing the import to skip over this row and continue importing.  Then I could print a report showing the row numbers of any CSV rows that failed the import due to the above-described error.

Please can you show me how to programatically (JScript) perform the CSV import using my CSV Import Specification 'CMDB_DISCOVERY_NODE'.

[Geert Bellekens]

My Simple VBA Excel importer might be of use.

Geert