Simple Access Question

[k12hugh]

I want users to be able to upload monthly excel payroll info into an access table, and then have that output into a report in access.

These payrolls have codes that need to tie to specific locations. Can access handle this all at once? If I made a separate table with payroll codes, and tied that to my main table of raw excel data, would access automatically retrieve the appropriate codes for each?

Thanks

 

[HiTechCoach]

Yes. That is what a relational database,like Access, is designed to do.

Not sure what you mean by "automatically retrieve". For your report, You can use a query to relate the tables together together then Access can "automatically retrieve" the related data.