I need to access MS Access db and loop through the tables. if the total number of the records exceed 10,000, I will create another file. so if I have 100,000 records in the file, I should create 10 files out of it.
I have little idea of how to implement it. does anyone have any idea?