Import 1 table to another in same file

[ph]

I have 2 tables in my database and I realize I want just one. Do I have to export to Excel and the import from Excel? I am dealing with a festival and one table is for "approved" artists and the other is for "potential" artists. I am now using radio buttons to separate them and can combine the tables. What's the best (read easiest) to do this? tia

[Wim Decorte]

Yep, export to a file and then import again. Ater the import and without changing the found set, run a replace on the radio button field to that the imported records will be properly marked as either approved or potential

[comment]

export to a file and then import again

Whatever for? You can import from a table in the same file directly.

[ph]

How? I've tried using import and it asks for the file name -- do Import the file I'm in? the database is one file, right? tia

[comment]

Yes, you import from the same file - different table. It will become clear once you're in the import dialog, where you can select the source and target tables.