HOWTO import only table's data

[fugifox]

I want to import data from one DB to another,
but only data without affecting the table structure and names.
In the import dialog box has only two options,
import tables and data
import tables only.
I want the third one
import data only.
Is there any automatic way or do I have to make a VB sub?

What I'm doing now is to importing tables and data
to the second DB, but as u know this results in having every table
twice like Students Students1 Classes Classes1 and so on.
Then I'm removing one by one all the old tables and then renaming every the
Table1 to Table.
As you can imagine this is not a practical solution and it can be implemented only to small DBs, with a small number of tables.
In my case we are talking about a huge DB with over 20 tables,
and the above process (importing data) has to be done at least once per month.

Let me inform you that copying data and only data from one base to another is the only method suits in my case so please avoid suggesting alternative solutions.

Thanks in advance

 

[FoFa]

Link the table and run an append query

 

[jeremypaule]

link the table like he said and maybe instead of an append query do a make-table query

 

[fugifox]

Thanks for the immediate reply.
What I am looking for is an automated process for the simple user,
pressing a button and ready.
I suppose can't avoid programming a VBA sub.
Can you give some guidelines about linking and appending/making table queries.
Let me inform that I am not a VBA beginner, I'm asking only about those specific commands which will help me from hours of searching.
Concerning your suggestion now, although it releases me from the burden of renaming and removing I still have to do the process of linking table for every single table don't I?
thnx again

 

[FoFa]

Using a linked table, and an append query to your current table can be done the way you are describing.
Is the issue the table you wish to import is not a static table somewhere?
Maybe if you expand you question we can help more.
Not saying VBA is not required, we just not are understanding.

 

[fugifox]

I'll try to put it as simple and extensive as possible.
I am responsible for the DB of a private school which has 4 departments
in different places of town.
If an error occurs or more possible if they want to add a new feature to the DB I just can't go to each department and make the same changes.
So I have the original DB at office and adding or changing everything they is needed and then asking them to mail me their copies of the original one.
Then I am following the process I've described in my first post and mailing back the changed DB (with the new features) to all depart.
So I need an automated process to avoid all these mailing mesh
and to just mail them a clean copy to all dep. and then
to be able by pressing a simple button to copy all their data to the new DB.

 

[RuralGuy]

Now you understand one of the biggest advantages of splitting the db into FrontEnd and BackEnd.