| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Using SQL in Get External Data
I want to populate my spreadsheet with data from an external SQL Server
database. I've setup the ODBC data source as a DSN name and can access the database's data with no problem. My question is how do I run an SQL SELECT statement against that database. Where can this statement reside? Thx all |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
|
Using SQL in Get External Data
Hi
I'm not overly-knowledgeable about this, but I use Data / Get External Data / New Databse Query (on XL2K) Hope this helps. -- Andy. "Hall" wrote in message ... I want to populate my spreadsheet with data from an external SQL Server database. I've setup the ODBC data source as a DSN name and can access the database's data with no problem. My question is how do I run an SQL SELECT statement against that database. Where can this statement reside? Thx all |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using SQL in Get External Data
Hall
Here's some info to get you started http://www.dicks-clicks.com/excel/ExternalData.htm -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Hall" wrote in message ... I want to populate my spreadsheet with data from an external SQL Server database. I've setup the ODBC data source as a DSN name and can access the database's data with no problem. My question is how do I run an SQL SELECT statement against that database. Where can this statement reside? Thx all |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using SQL in Get External Data
Two methods:
Data... Get External Data... New Database Query should bring up Microsoft Query (assuming it was installed as part of the Office installation). You can build your query in there, send the results back as a range (query table) into your spreadsheet. Then updating is a breeze - can even add parameters based on cell values. See help or search MSDN for more. Other method (for small amounts of data) is the SQL.REQUEST function - see Help. Ken -----Original Message----- I want to populate my spreadsheet with data from an external SQL Server database. I've setup the ODBC data source as a DSN name and can access the database's data with no problem. My question is how do I run an SQL SELECT statement against that database. Where can this statement reside? Thx all . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
| Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
| Tool bar: Data/Import external data/New database query | Setting up and Configuration of Excel | |||
| updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
| External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
Hybrid Mode
