Hi All,

The 6 staff I employ send in their expenses every 2-4 weeks.

On the expense sheet is their name, employee number, as well as expense amounts under certain categories (e.g. food, travel, phone).

What I am wanting to do is create a macro which will have Access look into a folder to check for the existence of expense sheets.

If there are any I want it to import all of the totals from each column into the database, then move the files into a subfolder in the folder.

Is this a massive task?? Hints/tips appreciated.

Thanks.