Import Text Files

[MadMax7]

I get sent 30 text files daily that i need to import into a table (tblIndividualTelephonyStats) each file is named different ie the staff members name.

the problems, at the moment i am having to import each file and then update a field (name) in the table with the name of the file (staff name) manually.

I was wondering if there is a way to another access table (tblstaff this table has a full staff list)check to see if there is a txt file with name and then import that file into tblIndividualTelephonyStats and updating the field name with the file name


hope this makes sense

 

[PHV]

Take a look at the Dir function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886