Page 1 of 1

Append Tables?

Posted: Wed Nov 28, 2007 3:19 pm
by mbsimpkins
I can not find a way to append tables in the Base program. I've got, three different tables I want to append into one table.

How is this handled in Base? :?:

Re: Append Tables?

Posted: Thu Nov 29, 2007 5:20 am
by bluebird
Here's what you can do

go to the main listing tables.

Now assume you have
-->table1
-->table2
-->table3

put your mouse over table2 and single left click
then right click, and select edit copy

put your mouse over table1 and single left click
then right click, and select edit past

a dialog will come up
change the table name to table 1
and select the append data radio option
double click on the create button

I assume the table field names are the same, so no adjustments have to be made
double click the (new) create button.


Also note that from the main table listing and the main query listing you can drag the data into a calc spreadsheet by dragging the table/query name into the spreadsheet window.

You can also append an edit-copied region of a spreadsheet into a table by pasting over the table/query name.

Hope that works for you.