Hi,
Any idea why I might be getting the above for one of the fields when I use VBA and use excel as a database? I'm using the "Microsoft.Jet.OLEDB.4.0" driver, and the strange thing is when I retrieve this field from the table in the database, there isn't an error, it's only when I'm inserting. I have set the field type to text. I'm using ado connectivity:

Code:

Code:
rs.Open "SELECT * FROM [tblCustomerSection$]", conn, adOpenStatic, adLockOptimistic, adCmdText
rs.AddNew
rs.Fields(0) = requestNoSubstringed
rs.Update
rs.Close
Set rs = NothingFails on update.
Thanks,