Update or Append Query

  • Thread starter Thread starter SHart
  • Start date Start date
S

SHart

I originally set up a different database for each of my
clients. I have since learned that this is not the way
to do it, but to put them all in one and then run queries
for each particular client. Anyway, I want
to "copy?", "append?", "update?", so I can transfer the
data from one database to the other. How do I do that?

Thanks in advance.
 
You first need to create a new table with the proper layout of where you want your data to go to

From your post, it seems that you have several tables, one table representing each client. I also imagine you have basic info on each client, ie, first name, last name, address, phone number etc.

Create your new table with the proper layout. create a primary key in the first field. IE Client_ID. Then add the same fields that you have in the mulitiple fields with the same field type settings

You can then run a simple query of your multiple fields one by one and append query them to your new table. HT

Eskimo Going Nuts
 
I originally set up a different database for each of my
clients.
Click to expand...

A different *database* - .mdb file? Or a different *table* within a
database? The answer depends strongly on which you mean!
I have since learned that this is not the way
to do it, but to put them all in one and then run queries
for each particular client. Anyway, I want
to "copy?", "append?", "update?", so I can transfer the
data from one database to the other. How do I do that?
Click to expand...

An Append query will add the records from one table as new records in
another table. If the tables are in separate databases, you'll want to
use File... Get External Data... Link to link to one of the other
databases and base the append query on that linked table.
 
Back
Top