Excel Imports

[SamSlade]

I am not very familiar with access so I suspect this is incredibly elementary - however help would be greatly appreciated.

We have a payroll system that exports basic timesheet information into Excel. The fields in question are Date, Employee No, Job Number, Hours and Rate. Obviously an employee can work on a number of different jobs on one day and can log the same job number more than once on the same day.

I want to avoid having to create ant kind of additional fields in Excel but what I need to do is to ensure that the timesheets are not imported into my Access database more than once. I could add a Pay Date field or create another table that just holds pay dates that have been imported but somehow before the import is carried out I need to do a check that the pay date has not already been imported

Can anyone give me a blow by blow method bearing in mind that my Access knowledge is extremely basic?

Many thanks

 

[giacomo]

Rather than trying to apply the restrictions ahead of time I believe it will be a lot easier for you to import the data into a temp table, then do any clean-up/validation needed, and then append it into your production table. That's how I do it anyway.

hth,
Giacomo