Insert stmt takes lots of time

[vish6]

Hello

I m using VB6.0 and Access.
I have problem that it will take lots of time when i m going to insert for 1000 of records
means it will take 4-5 min for 1000 records

What i m doing is as follows.

Excel sheet contains only 4 cols as empid,emppfno,empname and basic.while inserting in calcTable on basic calculations are done .

I m reading Employee data from excel sheet by simple select stmt and recordset.
after tht i m checking availbilty of tht emp means its entry already exist or not.
if not then only inserted in empmaster table.
Again i m chking tht emp is exst in another table "CalcTable" or not, if not then inserting in calctable.
here while inserting record in calctable i m calling functions for calculation in insert stmt.
Plz tell m the solution.

 

[JerryKlmns]

Please show us your Insert statements. Crystal ball on maintenance for a week.

BTW your insert SQL statements could
a] insert only new records
b] insert only new records and update fields of the old ones!
without checking for existance.

Calculation functions could also delay process. If you like post them too.