Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
out of the ordinary question
I was working on a spreadsheet (xl-2k) and someone said
use a sql to get the answer. Needless to say, I looked at them like a deer in headlights. I've been working on spreadsheets for awhile and never heard of using sql. So, here is the out of the ordinary question; can you use SQL queries in Excel? If so, how is done? Or if there is some documentation I can read about it. Like I said, out of the ordinary. Thanks to anyone who responds. *** John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
out of the ordinary question
John,
Not at all as out of the ordinary question as you suppose. Yes, you can treat Excel as a SQL data source and execute queries against it as you would a database. SQL is very powerful but not especially simple to learn and starting by using Excel as a datasource is not the best idea. It sounds to me like the casual comment "use SQL" to get results in Excel is a little like telling someone who wants to get rich to "first, get a million dollars." Look up SQL, ADO, ODBC, MSQuery. If you search for these topics in conjunction with Excel, you will find discussion about getting data into and out of Excel using database-like access methods. In Excel, look at Import External Data under the Data menu. If you think it is worthwhile, consider putting your data into one or more tables in Access and work with it there. Access will offer a more natural environment for executing SQL against your data. It is relatively easy to import data from Excel into Access. Bob "JohnE" wrote in message ... I was working on a spreadsheet (xl-2k) and someone said use a sql to get the answer. Needless to say, I looked at them like a deer in headlights. I've been working on spreadsheets for awhile and never heard of using sql. So, here is the out of the ordinary question; can you use SQL queries in Excel? If so, how is done? Or if there is some documentation I can read about it. Like I said, out of the ordinary. Thanks to anyone who responds. *** John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
out of the ordinary question
Bob, thanks for the info. My excel work has been with
formulas and vba. I guess once you find you niche you tend to stay with it. Yet, change is a good thing. I have already begun looking into it sql for excel. I am familiar with sql from working with a2k. So hopefully the learning curve is a short one. *** John -----Original Message----- John, Not at all as out of the ordinary question as you suppose. Yes, you can treat Excel as a SQL data source and execute queries against it as you would a database. SQL is very powerful but not especially simple to learn and starting by using Excel as a datasource is not the best idea. It sounds to me like the casual comment "use SQL" to get results in Excel is a little like telling someone who wants to get rich to "first, get a million dollars." Look up SQL, ADO, ODBC, MSQuery. If you search for these topics in conjunction with Excel, you will find discussion about getting data into and out of Excel using database-like access methods. In Excel, look at Import External Data under the Data menu. If you think it is worthwhile, consider putting your data into one or more tables in Access and work with it there. Access will offer a more natural environment for executing SQL against your data. It is relatively easy to import data from Excel into Access. Bob "JohnE" wrote in message ... I was working on a spreadsheet (xl-2k) and someone said use a sql to get the answer. Needless to say, I looked at them like a deer in headlights. I've been working on spreadsheets for awhile and never heard of using sql. So, here is the out of the ordinary question; can you use SQL queries in Excel? If so, how is done? Or if there is some documentation I can read about it. Like I said, out of the ordinary. Thanks to anyone who responds. *** John . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
out of the ordinary question
See:
Free Interactive Online SQL Training http://www.sqlcourse.com/ -- "JohnE" wrote in message ... I was working on a spreadsheet (xl-2k) and someone said use a sql to get the answer. Needless to say, I looked at them like a deer in headlights. I've been working on spreadsheets for awhile and never heard of using sql. So, here is the out of the ordinary question; can you use SQL queries in Excel? If so, how is done? Or if there is some documentation I can read about it. Like I said, out of the ordinary. Thanks to anyone who responds. *** John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Question about {} | Excel Worksheet Functions |