Copy records between tables

[mleiser]

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?

[Lee Smith]

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

[comment]

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.