damo Posted January 27, 2005 Share Posted January 27, 2005 I am redesigning one of my old databases. What was 2 fields on the old database I have now set up as 1 field in the new one. Each record in the old database only has information in 1 of the 2 fields. When I import the old data, I want it to bring in information from both the fields into one. Is there a way I can do this? Link to comment Share on other sites More sharing options...
Ted S Posted January 27, 2005 Share Posted January 27, 2005 damo, My first instinct would be to create a new field in your OLD DB that was a combination (calculation) of the two fields and then export/import the contents of only the new field. Maybe something as simple as: SetField [NewField; OldTable::OldField1 & OldTable::OldField2] Link to comment Share on other sites More sharing options...
transpower Posted January 27, 2005 Share Posted January 27, 2005 Or you could do it the other way: create another field in the new database and import. Then set the first field in the new db to the other field if it (the second field) is not blank. Then delete the second field. This way you keep the integrity of your previous db. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7029 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now