importing and updating

[Guest]

With the help of this forum I have been able to perform major improvements to
my database. Beginning from an Excel spreadsheet and one large table I now
have related tables with queries for my reports instead of a mess of
individual macros and reports with filters for each of many dept heads.
Special Thanks to John Vinson and "The Blue Rabbit" Lynn Trapp, and also Ken
Snell and Wayne Morgan, its hard to express the appreciation for your
guidence.

Now that I have done all this on a "copy" that is now two weeks old, should
I import the current tables into the copy.....or work on the current
database..splitting the table and forming the relationships and then import
the objects I created? I haven't found an article to reference on this.

Thank You again.

 

[Joseph Meehan]

With the help of this forum I have been able to perform major improvements
to
my database. Beginning from an Excel spreadsheet and one large table I now
have related tables with queries for my reports instead of a mess of
individual macros and reports with filters for each of many dept heads.
Special Thanks to John Vinson and "The Blue Rabbit" Lynn Trapp, and also
Ken
Snell and Wayne Morgan, its hard to express the appreciation for your
guidence.

Now that I have done all this on a "copy" that is now two weeks old,
should
I import the current tables into the copy.....or work on the current
database..splitting the table and forming the relationships and then
import
the objects I created? I haven't found an article to reference on this.

Thank You again.

Maybe someone else can, but I can't think of a reason to do it one way
or the other.

 

[George Nicholson]

If your 2 week old "new" db has the structure and functionality you want
then importing current data into the new structure sounds like a lot less
re-work than doing it the other way around (which would still involve
getting the data into its new structure PLUS adding all the other design
changes).

The less re-work, the less chance you have of forgetting something or
introducing an unintended error by mistake.

But make lots of backups before you start.....