|
|
I have received a task to create a report for our email useage locally. There
is a specific userface we use for emails that I receive an extract of data.
Each day I receive an excel file which contains columns such as thread id and
name and subject line. In addition i receive about 1000 dat files that
correspond to each thread ID in the excel file. the dat file is named for the
thread ID and inside the dat file contains the body of the email thread.
I would like to automate the process of importing the dat files into a
single table with the name of the dat file becoming a value in a column of
the created table while preserving each body text as a memo field. This would
allow me to easily run reports on what our standard reply useage along with
identifying which keywords have the greastest volume in our company at the
moment. Any ideas?
|
|
|