Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC
Hi, Is there a way to run sql queries on Excel 2007? For instance I would like to build a table and select certain rows using sql script. Thanks, D.
Or you can go to Data-->Import External Data-->New Data Query-->then choose your table and pull in your Query
Posted on Apr 17, 2008
Yes, there is if you have Access as well. You can declare your Excel spreadsheet a data source in Access and then query using SQL. To do that, create a new DB and select Insert --> Table --> Link Table. Change "File of type" to show all files and select your Excel spreadsheet. Follow the wizard and you'll have a link to the sheet and can query it as if it were a table in access. However I doubt you really need that. Excel's functions should be a match for most queries. Can you give a sample of what you try to query (or why you want the SQL queries?
Posted on Aug 14, 2007
If you just want to do criteria-based queries, you can get a reasonable approximation to a "SELECT ... WHERE ..." kind of query by using the VLOOKUP function in Excel. Then you don't need to use a database, although you may need to specially format your excel data - just read the help file about VLOOKUP.
Posted on Mar 09, 2010
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
May 16, 2009 | Microsoft Windows Vista Ultimate Edition
Feb 05, 2009 | Microsoft Computers & Internet
Dec 11, 2008 | Microsoft Computers & Internet
Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...
Jan 25, 2008 | Computers & Internet
Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...
Aug 23, 2007 | Microsoft SQL Server Standard Edition for...
16,029 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: