Hello

I am sure that some body must know how to do it. I am going to transfer data in Word table into Access table, however the data type in one of the Access field is Number, I have to convert the data in Word into number so that the type does not mismatch. The part of code as:

Set rs = dbs.OpenRecordset("Action", dbOpenDynaset)
With rs
.Addnew

!ActionID = TrsTable.Cell(i, 1)


The ActionID is the field name in Database table Action, the type is Number

I tried !ActionID=CInt(TrsTable.Cell(i, 1)), it does not work.

Any help please?

Thank you