I don't know where I got Exec() from, it should have been Execute(). But at any rate, no, nothing gets in the table if I stop things prematurely. Which doesn't make a lot of sense to me because each insert should be a discrete "transaction" and not dependant on the others.

Hmmm... I wonder if certain properties can be set on the connection object to make it always flush things?


>
>You don't get an error at the Exec line? The correct method is Execute(). Otherwise it should save rows up to the exception point, although I tested this with VFP.