i can user external tables to transfer data from txt files to database..is their any way to transfer multiple files? like i have 20 txt files and i want this to be done automatically without specifying the file name again and again..i also want to schedule this task..so that daily @10a.m this routine should run and transfer the data from txt file to database.

An early response is apprecoated.

Regards,
Abrar