Solution Advice

[mouse88]

I am trying to come up with a solution for a project in work.

I started looking at excel but access may be a better option.

Basically I need managers to be able to add records to either a database table or spreadsheet table on staff activity.

Easily done in Access just set up a table and a data entry form and job done.

The problem I have is there is other data that comes from an excel spreadsheet exported from our telephone software. I would need to get this data in to the access table and link it up with the existing records.

Can anyone offer any advice?

 

[Joe4]

You can link or import Excel files to Access tables. One advantage to linking it is if you make any changes to your Excel table, it will be automatically reflected in that linked table in Excel without having to do anything special (like re-importing the data).

The important thing is to have common fields between your different tables, so they can be easily linked.

If you do decide to go the Access route, the important thing is create a good database design so that it allows you to do what you want easily. Understanding the concepts of relational database and normalization are key.

 

[mouse88]

Right ok so my access table and excell table, would they need to have a primary key to link them up?

 

[alansidman]

Yes. As Joe said in his thread

The important thing is to have common fields between your different tables, so they can be easily linked.

Alan