Importing Tables

  • Thread starter Thread starter Amin
  • Start date Start date
A

Amin

So I have a series of queries that I run on Table A. Each month, I get a new
updated table, Table B. What I would like to do is change the queries that I
run on Table A to Table B without having to go into the SQL to manually
change their names. I know this is a stupid question, but please help
regardless. Thanks so much!
 
Amin

What you didn't say (but implied) is that "TableB" has exactly the same
fields/structure as "TableA". If that's the case, why keep two tables? Why
not append the data from TableB to TableA, then run the query there?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes, that's a muchbetter idea! Yes, the two tables have the exact same
field/structure. How would I append the tables?

Thanks so much,
Amin
 
Amin

Create a query that returns the records you'll want to be appending.

Open the query in design view and change it to an append query. This will
cause Access to prompt you for the name of the "append-to" table, and you'll
need to be sure that you've correctly identified the "append-to" fields.

NOTE: before running a query that alters data (e.g., an append query), make
sure you have a backup copy of your Access database!


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top