Table Mapping

[jez123456]

Hi

I'm in the process of migrating a legacy database into Access and need to map the data fields. Are there any tools/templates that I could use to help document the table mapping. Some tables are straight copies, but some have new fields etc.

Thanks

 

[Pat hartman]

When I have had to do this in the past, I have used Access tables. They are exellent for sorting/gouping/querying. Start with a table that looks like:

tblConversion:
OldTableName (pk field 1)
OldColumnName (pk field 2)
NewTableName (unique index field 1)
NewColumnName (unique index field2)
ConversionTable (if the data is a code, this is the name of the table that maps the old codes to the new codes)
Comments

If you have old data that was improperly stored and now needs to be normalized, you may need to make this a 1-many relationship so that the old Name column can be broken out into FirstName, LastName, etc.