So we have FileMaker Pro here and it holds our equipment inventory, however there are a few fields that I have been wanting to add to it but the DB Administrator won't add them. Keep getting the I can't add anything once it is created, I am sure they could, but either don't want to or they need to run it through a CCB.
So I can export the equipment inventory to excel, which is great.
But I want to link or import it into access and add the fields we need there.
So here is what I am asking:
Would it be easier to link the spreadsheet to the database and if so how would I add my extra fields?
If I have to import it I can add the field there but how would I update the data from FileMaker pro each time I updated the imported spreadsheet without affecting the fields I have added?