Import data from another table

[xfile]

Hi:

How can I import data from another table, instead of the entire table, to
the current table?

Both database files are Microsoft Access (2003 edition), and my purpose is
to keep one database file as the central file while periodically collect (or
import) other database files with updated information.

I have tried using import wizard, but it would import the entire table as an
additional table of the file.

Many thanks in advance, and I am new to database, sorry.

 

[Randy Balbuena]

Hi:

How can I import data from another table, instead of the entire table, to
the current table?

Both database files are Microsoft Access (2003 edition), and my purpose is
to keep one database file as the central file while periodically collect
(or import) other database files with updated information.

I have tried using import wizard, but it would import the entire table as
an additional table of the file.

Many thanks in advance, and I am new to database, sorry.

XFile,

I'm not sure if I understood, but it sounds like you want to import records
from one table, into another table.

If the file was a text file you would have to watch for the step 3 of the
Import Text Wizard, which asks you for importing the records to a new or
existing table. However, in your case, I would suggest to create a
link-table on your central database and create an Append-query or a
Make-table query that will replace your current import process. The source
for these queries will be the link tables, and the target will be a new
local table name. When running a make-table query, a table will be created.
Then you just have to run the query to have a local and updated copy of the
tables/record created remotely.

Hope this helps.

 

[xfile]

Hi:

Thanks for the kind reply and suggestions from both of you.

Sorry for the confusion since I am new to the database field.

The scenario goes like this:

I have a database file - called A, which is stored at ISP's site used for
membership registration and logon process. As you can image, the database
will be changed periodically based on additional sign up or cancellation of
membership (I am still figuring out how to delete although I know how to add
from Web Form, just a note)

Then I have another database file - called B, which is used for email
newsletter or announcements to subscribers. However, B's record sources
will include A and other sources, such as business communications and
visits.

In addition, there will be other data sources, as you mentioned, in the
future from other fields.

I wish to make B as the central database for all outbound email messages,
and contain only the latest and updated records from other sources, such as
A.

I figure that if I use only one database file for all purposes, I might need
to change the table fields consistently especially in the beginning, since I
don't know exactly what information might be needed for each purposes. So I
figure that it will be best to separate each database files for their own
purposes, and just import them if needed.

I hope this clarify the situation.

Once again, many thanks to your kind reply.

 

[xfile]

Hi:

Thanks and I will try that.

I would link to the table A from B. That way you will always have the
current data available, no need to update or edit. If there is a need to
change table A's format, you may need to adjust, but no matter what method
you use, you would still need to do that.