I've been given the task of transfering data from an access db to sql
server 2000. The previous access db was not structured very well so
we reconstructed the tables in sql server 2000 to add better table
structure and more functionality. What I want to be able to do is
transfer the actual data in the access tables to the new tables in
the sql server 2000 db. Does anyone know of a simple way to do this?
I've been looking into CA solutions' Allfusion Modeling Suite but i'm
not sure if it could handle what it is i'm trying to do. If anyone has
any suggestions please help me out.

Thanks in advance,