Hello,
I have recently started using access. I am not sure if what I need to do is possible.
I have a database that I am using to house employee information and performance.
The application we use to measure quality exports the information into excel but doesn't date/time stamp each entry.
I am looking for a way to program access to automatically link excel files that I drop into a directory. I would name them stats.week9.xls as a standard convention or something like that.
I would just append the records to a table but since there is no time date stamp I would not be able to differentiate one weeks score from the next. And I would like to keep previous weeks.
The first row is always the field name
And field names are always the same
If this is possible I would also like to automatically set a relationship to another table.
Thanks,
Steve
I have recently started using access. I am not sure if what I need to do is possible.
I have a database that I am using to house employee information and performance.
The application we use to measure quality exports the information into excel but doesn't date/time stamp each entry.
I am looking for a way to program access to automatically link excel files that I drop into a directory. I would name them stats.week9.xls as a standard convention or something like that.
I would just append the records to a table but since there is no time date stamp I would not be able to differentiate one weeks score from the next. And I would like to keep previous weeks.
The first row is always the field name
And field names are always the same
If this is possible I would also like to automatically set a relationship to another table.
Thanks,
Steve