When doing an RE7 import you can opt (in code, using an object property, for example) to have table entries created automatically. Is there any way to do this when adding records using the API? Currently the only way I can see how to overcome this is when an error is returned (entry doesn't exist in code table) the record has to be added manually. 

There is no automatic add to code tables value in the API. You have to first check to see if the value is in the code table and then if it is not you have to add it. If you are interested I can dig out some code for you.

 David

oAttributeTypeServer = (rs.CreateServiceObject(BBREAPI7.bbServiceObjects.bbsoAttributeTypeServer)) as CAttributeTypeServer;

oAttributeTypeServer.Init(ref _context);

try

int lcodetableid = oAttributeTypeServer.GetAttributeCodeTableID(oAttributeTypeServer.GetAttributeTypeID("Academic Program Description", bbAttributeRecordTypes.bbAttributeRecordType_EDUCATION));

//here lcodetableid value is 1028 but i cannot find in ECodeTableNumbers class

The ECodeTableNumbers enum is just the numbers of standard (not user defined) code tables. You will not find your code table in this enum. However if you want to add an entry to a code table you need to use the following code (you will need to translate the VB.NET to C# but it is pretty straight forward -  you will just need to handle the "optional" parameters)

   Public Sub addToCodeTable(ByVal shortValue As String, ByVal longValue As String, ByVal codeTable As Integer)

        Dim tableLookupHandler As CTableLookupHandler


        tableLookupHandler = _REServices.CreateServiceObject(bbServiceObjects.bbsoTableLookupServer)
        tableLookupHandler.Init(_SessionContext, _CodeTableServer)

        oTableLookupHandler.AddEntry(True, codeTable, shortValue, longValue)


        tableLookupHandler.CloseDown()
        tableLookupHandler = Nothing

    End Sub