SQL queries in ACCESS

[tealeaf]

Hi this is my first time working with access. Mostly I work with Excel. At any rate, I'd like to know how I can make some sql queries to existing databases on my company network.
For example in Excel i went to data>get external data>new database query.
now i'd like to do the equivalent in Access. does that make sense?
like i have the database somewhere on the network and i want to extract a table into access.

 

[Philem]

Hullo. This is ceratinly possible. Going by the somewhat light information you gave, here are some general hints along the path: Make sure that Access can SEE the db on the network. How this is done will depend on the db type you are trying to touch. Once Access is able to see the database, you have a choice; you can Link to the table you need, thereby making sure that changes to the source are reflected in your local table, you can Import the table, thereby allowing for use when the source table would otherwise be offline as well as having some slight increase in speed at the cost of having stale info.

HTH

P

 

[tealeaf]

thanx so much for ur help. i managed to link the external database as u say. now i have a new obstacle. how can i go about putting a criteria on the date field? i only want the last few months but the table i'm linking has the last 15 years! so it's really too big.