Importing data to Excel using MS Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Query setup 0
Access #Error & Excel Pivot 0
Data Import into Excel 3
Import Data from Access query 8
Error Editing an MS Query in Excel 1
Import External Data 3
Applying Criteria in Excel Cell to MS Query Pull from Access 1
importing/linking data from an Access 2003 Query to an Excel 2003 2

Back
Top