Append Tables?

Creating tables and queries

Append Tables?

Postby mbsimpkins » Wed Nov 28, 2007 3:19 pm

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? :?:
mbsimpkins
 
Posts: 3
Joined: Tue Nov 27, 2007 8:42 pm

Re: Append Tables?

Postby bluebird » Thu Nov 29, 2007 5:20 am

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.
bluebird
 
Posts: 9
Joined: Wed Nov 28, 2007 5:18 am


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 4 guests