Ok, I am creating a new database to track the progress of the collecters at
my office. Some of the data I need is stored in a SQL database at out
corporate office. How could I import this data from the SQL database into
the Access database? I will also need to filter this data as it comes to
ensure that only the data for Collector A is appended to Collector A's Table
and that only data for Collector B is appended to Collector B's Table and so
on. Any clues?

1. Start Access by opening a new or exsting database file (depending your
need and/or what you already have);
2. Click menu "File->Get External Data->Import... (or Linked table...)
depending on your need;
3. Follow the wizard.


"Jeremy Anderson" <Jeremy (E-Mail Removed)> wrote in
message news:5D7272CD-8CC9-416F-85C7-(E-Mail Removed)...
> Ok, I am creating a new database to track the progress of the collecters
> at
> my office. Some of the data I need is stored in a SQL database at out
> corporate office. How could I import this data from the SQL database into
> the Access database? I will also need to filter this data as it comes to
> ensure that only the data for Collector A is appended to Collector A's
> Table
> and that only data for Collector B is appended to Collector B's Table and
> so
> on. Any clues?

Go back a bit: If you have a separate Table for each Collector, your
database is likely to have an incorrect Table Structure.

You should combine all of these "similar" Tables into ONE Table with an
additional Field to indicate which Collector the Record belongs to ...

Suggest you check your Access books / Relational Database Design Theory
books on how to design a database with appropriate Table Structure.

See also the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=234208

Only after you have the correct Table Structure set-up, you can then proceed
to import the data.

--
HTH
Van T. Dinh
MVP (Access)



"Jeremy Anderson" <Jeremy (E-Mail Removed)> wrote in
message news:5D7272CD-8CC9-416F-85C7-(E-Mail Removed)...
> Ok, I am creating a new database to track the progress of the collecters
> at
> my office. Some of the data I need is stored in a SQL database at out
> corporate office. How could I import this data from the SQL database into
> the Access database? I will also need to filter this data as it comes to
> ensure that only the data for Collector A is appended to Collector A's
> Table
> and that only data for Collector B is appended to Collector B's Table and
> so
> on. Any clues?