How do I import data from SQL into Access?

[Guest]

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?

 

[Norman Yuan]

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.

 

[Van T. Dinh]

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.