Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

4 Answers

Running SQL queries on Excel

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.

Posted by on

4 Answers

  • Level 1:

    An expert who has achieved level 1.


    An expert whose answer got voted for 2 times.

  • Contributor
  • 2 Answers
Re: Running SQL queries on Excel

Another way to do it is to use the SQL Drill freeware Excel addin (

Posted on Apr 21, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer
Re: Running SQL queries on Excel

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

  • Level 1:

    An expert who has achieved level 1.


    An expert that has over 10 points.


    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers
Re: Running SQL queries on Excel

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

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has answered 20 questions.

  • Expert
  • 55 Answers
Re: Running SQL queries on Excel

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

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

How to Change SQL Server 2005/2008 User Password

There is one SQL password recovery tool, SQL Password Genius, which would help you to successfully change SQL Server 2005/2008/2012 user password instantly, especially when you couldn't think of other ways for it.

1. Open SQL Server Configuration Management and stop SQL Server Services.

2. Install SQL Password Genius full version and run it on computer.

3. Click "Open File" button to import master.mdf database file into this recovery tool.

4. Select user in list and click "Reset" button.
Instantly, new user password would be available for SQL Server logon after you type new password for user.

Now, SQL Server user password has been changed and you can login into SAL server now. But please remember to restart SQL Server Services before you access to SQL Server with user password.

Jul 04, 2014 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

Steps in saving file in excel to database

severals solution :
- save file as text separated by comma and use sqloader from oracle
- use function in excel to concatenate insert order : "insert into TABLE_NAME (field1,...,fieldn) values (A1,B1,...,??n);". Save file as text with sql extension. Connect against roacle db and execute file previously saved.
- use ODBC from MicroSoft

Dec 11, 2008 | Microsoft Business & Productivity Software

1 Answer

After installing DB2 query is not executing

could you check whether you are connected to the database, where you are trying to create table,

check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

Sorting Imported sql data

Are you sure you imported the data or did you create a link to sql. If it is a link then it will not allow you to work with a subset of the data because it would effect the data on the sql database.

Apr 11, 2008 | Microsoft Office Professional 2007 Full...

4 Answers

Restoring files from the database

I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.

oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup

Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Query for retrieve the data

so, are you looking for the query statement to get this info...

And, upon entering the 6th digit, your code will execute the sql query, such as:
SELECT cardnumber from <table_name> where cardnumber>='123456'

NOTE: replace <table_name> with the name of your table.

You might have to modify the statement depending upon how your calling it.

Check out more info at

Hope this helps.

Jan 25, 2008 | Business & Productivity Software

1 Answer

SQL server won't work on my laptop

Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.

SQL Server runs on port 1433, so any firewall has to have it open.

Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.

Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.

Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

3 Answers

Viewing ms Sql Server database on Access

Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

16,010 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides