Faster Way To Add Records To Any Table
Version Compatibility: Visual Basic 6
The class, clAddRecord, will allow you to insert a record into any given table, generating a temporary stored procedure. This method is 4 to 5 times faster than the method of opening a recordset, adding the new records and updating to the database. It is also independent of the actual size of the table. The project currently uses MS Access and be sure to change the connection string accordingly.
Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.