Creating a database from an already created database

5 pts.
Tags:
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
ASKED: May 24, 2012  3:19 PM
UPDATED: May 24, 2012  4:13 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following