Hi jmcilhinney

The app uses an entity attribute model allowing for different datatypes to be stored ie Alphanumeric,Date and numeric.

For example
Entity: Company
Attributes
Company Name : Alphanumeric data
Number of Emps : Numeric data
Registration date: Date/time data

This data is then written to the different tables below:
tbEntAttAlphaNumericVal
tbEntAttNumericVal
tbEntAttDateTimeVal

The INSERT statements fire based on the fact that the value has been supplied if it is Mandatory and the row is not blank.

From my original post

The conditions that must be met to insert data are:
Col(0) must contain a value
If Col(4) is "Mandatory" Then Column 3 must have a value.

Where can i find code to implement your suggestion of datatables and loops?