An append query is used to append data to tables.
If you link your excel spreadsheet (File - Get External Data - Link) you should be able to append fields to it from other tables within Access.
I think what you mean by "a query which makes a search" is just the standard way that queries use parameters to limit what shows up.
Try this:
Open up the QBE wizard and select your source table
After finishing, open up the query in design mode.
On the row labeled Criteria, add something. If it's a string field, it will put it in quotes and if you execute it, it will only show you items that match the string you type in...in that specific field.
After you do this, return to design mode. Change the query type to Append (tool bar at top) and type in or select the table name you wish to append the data to. Save the query.
Next time you run this query, the same information that appeared on your screen will be appended to the destination table.
-
Something to pay attention to. Access makes a 'guess' as to which fields in the source table to append to the destination table based on field names. If they don't match, you can still append, but you must go into the append query design mode to tell it where to send the field data. Make sure the field types are compatible (sending text to a numeric field!)
Mike
