Hi,
I have designed a databasewhich is now able to store all data from my
client's Excel sheet.Now I am looking for a good way to move their data
into this Db.
If I want to do this myself will it be enough to remove referentiol
itegrities from all tables or I need to delete all raltionships?
If I removed the relationships and entered data into the tables then
how should I put back the relationship?
If I don't delete the realtionships, Then access gives me an error some
times key violation and sometimes data integrity, any Idea how to
overcome these?
Is there any known procedure to move the data from an excell sheet to a
well designed DB in Access ,If there is I would love to know the
procedure.
Are there any good tools to do this?
I mean it is like tearing a shirt and changing its size and buttons and
probabley the looks of it but it would be still doing the same job
there must be an automated way to so!!?
Many thanks
Kindest regards