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.

 

[Joseph Meehan]

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.

How about a little more information about this need.

Why do you need to periodically collect information from other database
files?

Access offers some good tools to help you do this or avoid it all
together.

Many times it involves one or more laptop computer being used by office
staff out of the office. If this is the case, Access-Office have tools to
make synchronization easy and accurate.

If you have more than one person in the office working on the data and
you have a LAN then a split shared database is the way to go and will
eliminate this step all together.

 

[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.

 

[Joseph Meehan]

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.

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.

 

[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.