Importing records from the same file into new table
I am doing a bit of rearchitecting, and I want to move some fields from one table to a new table. So, I want to import the existing record data into the new table, too. I was trying to use the File -> Import Records -> File... option. Things seem to work quite well, except that I only end up with 1 record being imported from the source table, instead of the 3100+ that are there.
Any ideas? Do I have to export the record data to an external file and then import it?