Importing data to Excel using MS Query

J

John

I am importing data into Excel 97 using the data query functions and MS
Query. I can set simple criteria, but I am also sure I could do more with
this if only I knew how to. Could anyone recommend some (simple!) reference
material that explains more about setting up SQL queries.
TIA,
John.
 
R

Ron Coderre

This is a pretty good site for a basic MS Query tutorial.
http://www.rdg.ac.uk/ITS/info/training/notes/excel/query/

For learning SQL...I always recommend:
The Practical SQL Handbook: Using Structured Query Language

It's not Microsoft specific, but it will teach you what you need to know
about queries and basic data structures. That knowledge can be applied to
any database you may use.

Does that help?

••••••••••
Regards,
Ron
 
Top