Importing Tables

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!
 
J

Jeff Boyce

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
 
A

Amin

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
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top