Creating a database from an already created database
The HR department at my place of business has created an access database that I import weekly, they have set up most of the fields. They have not used normalization. How do I proceed to create a database for my department
Software/Hardware used:
Software/Hardware used:
ASKED:
May 24, 2012 3:19 PM
UPDATED:
May 24, 2012 4:13 PM
Answer Wiki:
Is there a reason you cannot just use the database that you import?
Are you importing the completed database or just changes?
What type of DB do you want to setup? DB2, SQL, ...
Once you have answered those questions, and you decide you want to create a relation DB; just design it however you want to use it. It makes no difference because if your input does not change, you will need to run a conversion program every time you receive a new file.
Read a record from the Access file and then write/update records in your DB.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
