mleiser Posted November 18, 2008 Share Posted November 18, 2008 I have a single table database. I want to make it relational. To start I want to copy all the records from table A into table B. In the table tab I can copy and paste and end up with a second table identical to the first with all the same fileds but no data. I want to duplicate the data as well. I don't know how to do that. After that I'll massage each one to make it relational. Bottom line I want, at first, two identical tables within my one database. Ideas? Link to comment Share on other sites More sharing options...
Lee Smith Posted November 18, 2008 Share Posted November 18, 2008 (edited) Each Table is a different File. You can copy and paste the fields, but the data will have to be imported into Table B. HTH Lee Edited November 18, 2008 by Guest Link to comment Share on other sites More sharing options...
comment Posted November 18, 2008 Share Posted November 18, 2008 You can import the data into a new table in the same file (select New Table as the target in the import dialog). This will duplicate the data AND the field definitions. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5776 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