iam new in vba .. how to resume insert data from excel sheet to database after error occur

[bharat kumar]

i have 40000 records in excel sheet and i want to insert it into database . error occur after 2000 record , and it start from beginning . i want to resume it from 2001 and continue

any method for resume in vba??

 

[hiker95]

bharat kumar,

Can we see all of your macro code?


When posting VBA code, please use Code Tags - like this:

[code=rich]

Paste your code here.

[/code]