RE: Table Mapping
From: Pat hartman (Pathartman_at_discussions.microsoft.com)
Date: 07/30/04
- Previous message: Andrew: "Access XP & Windows 98/ME"
- In reply to: jez123456: "Table Mapping"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Jul 2004 11:41:02 -0700
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.
-- Bridge Players know all the Tricks "jez123456" wrote: > 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
- Previous message: Andrew: "Access XP & Windows 98/ME"
- In reply to: jez123456: "Table Mapping"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
