Include and work with external data

[Steph83]

Hello,

I have trouble with the following problem:

I have a project database in which I have a main table tblProjects and 3 detail tables tblCosts, tblSchedules, tblProjectEmployees. Those tables are linked by the projectID and the information is filled by the user.

Additionally I have three excel files with projects that are tracked in another tool. These excel files contain the same kind of information (fields) that is in my tables tblProjects, tblCosts, tblSchedules consist of.

Now, I somehow want to merge the 3 matching tables (through query or a new table?) to show the overall project portfolio with its costs, schedule etc.
The information that is imported should not be editable (this is done in the other tool). However, the information of tblProjectEmployees is not included in the external data, so it should be filled by the user for all projects

I hope the problem is understandable.

I'm using Access 2013 and I'm quite new to access.

Thanks for any ideas and help.
Steph

[NeoPa]

Hi Steph.

Can we assume you have a question in there somewhere? I'm sure you know we don't simply design things for you from scratch.

The explanation is reasonably well done so I'd like to encourage you to persevere, but perhaps read the instructions on posting new questions (How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!). Had it shown less effort to get it right I'd have simply deleted it, but as it's clear you've put real effort into it this is another chance to make it something we can help with.

One thing that isn't explained too well is how you plan to manage Employees as you have no Employee table as such.

NB. For other posters :
Responding to this request before it's been converted into a valid question is liable to result in deleted posts. Just so you all understand.

[PhilOfWalton]

Hi Steph

Neopa is right in that your question lacks detail as a stand alone question. I am aware that this is a follow on from https://bytes.com/topic/access/answe...related-tables, but other people will not be aware of that.

Might I suggest that you post an image of your relationship window and Project form.
Then give details of exactly what the Excel files consist of - 1 File containing a number of projects or multiple project files. Give some information on the Excel fields - then ask the question of how to merge the data.

Both Neopa and myself have ideas on what is needed, but you do need to give us the facts, then ask a clear specific question before we can be sure we are giving the correct advice.

Phil