Acces import data to Query

[flebber]

I am having a little problem understanding a concept.

Obviously data needs to be inputted or imported into tables for the
database to contain relevant records.

What process am I looking at if I want to import data to create a
query->calculation->report style process. What do I mean, say I had a
database that had basketball team records and I had imported the
results of the teams and the individual players latest games.

When Team A versus Team B the coaches announce their teams to play. If
there was only 1 game I could create a form for user to submit the
teams but when multiple events/games occur this is impractical.

If I can import the teams from the internet no manual data entry is
required, however there is no real need to store the values just
perform the function of retrieving data to a query and/or warning if
no record exists.

I know its probably a simple problem but I don't know what this
process is called and I can only find examples of normally importing
data into tables to store. I want to import data to no tables and
trigger a query or similar.

 

[Douglas J. Steele]

Queries get their data from tables, so you have no choice but to import to
the table if you want the data to show up in a query.

 

[flebber]

Queries get their data from tables, so you have no choice but to import to
the table if you want the data to show up in a query.

So whats the best method of acheiving the result I want?

 

[Douglas J. Steele]

You said you were able to find examples of normally importing data into
tables. That's what you have to do.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

Queries get their data from tables, so you have no choice but to import to
the table if you want the data to show up in a query.

So whats the best method of acheiving the result I want?