Well for example, i have a folder in C:Named Database. In that folder are files like:

patient.0001 etc etc

The name of the table would therefore be patient0001 in SQL, thats what i want to happen.

I then want my query to be run on this table, the query saved, and for it to go to the next File within the folder, So patient.0002

So loop through each file within the folder.

Any ideas?

Thanks

Rixxe.