| 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 |
| 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) | |||
Threaded Mode
