Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data to Excel using MS Query
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. -- John Reynolds |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data to Excel using MS Query
This is a pretty good site for a basic MS Query tutorial.
http://www.rdg.ac.uk/ITS/info/traini...s/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 "John" wrote: 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. -- John Reynolds |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 03 DB query pulls data in wrong order, how to resolve? | Excel Discussion (Misc queries) | |||
Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) | |||
importing data from the query wizard | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Help with Charting My Data -- | Charts and Charting in Excel |