Submitted by jimspoon on 2022/10/16 13:05

A special grid to be used for importing data into IQ.

Copy a range from Excel, Google Sheets, etc. and paste into the Import grid.  IQ recognizes the data type of each column.

The column headers in the Import grid are the destination fields in IQ.  If column headers are pasted from Excel etc., IQ uses these.  If the IQ database has no corresponding field for a column, it is created and assigned the detected data type.  The column headers are dropdowns from which the user can select any desired destination field.

Click an Import button and all selected rows in the pasted data are imported into IQ items.

 

 

Suggestions