ok, here is the next problem i am faced with.

If the user of my app wants to load a new file, i need to delete all the entries within my database table. what would be best way to do that

i was thinking

do while not rs.eof

rs.delete

thanks for all the help everyone