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 |
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 |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com