Merging two files into one

[John Chamberlain]

I Want to merge two related files into one.

 

As far as I know I will have to create a new table in file #1 with all the field names in file #2, then import the data from #2 int #1.

 

This is tedious as there are 50 fields in #2.

Is there an easier way to do this?

[Wim Decorte]

You can copy and paste the table

[comment]

Or you can just import the table, and specify New Table as the target table. This will recreate the schema and import the data all at once.