DATA TYPE CONVERSION Error with VBa

[Minty]

This is still a very clunky way of saving the information, when you could enter it directly into a bound sub form. IMHO.

 

[static]

Adding records one at a time via a recordset is much the same speed as inserting them with the same number of queries.

When we talk about queries being faster than recordsets, it is different context where the database engine is processing sets of records.

I obviously didn't think that post through at all.
I've come to think of SQL as the be all/end all but, yeah, in this case it isn't.
SQL is actually slower because of the need to compile and validate the query each time.

'test inserting 3000 records (time in seconds)
SQL insert using CurrentDb - 3.695313
SQL insert using DBEngine - 1.933594
SQL insert using DBEngine + transactions - 1.265625
insert into recordset - 0.4453125

I'd still use SQL though until performance made me switch.