Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tips on selecting SQL data into a worksheet?
I have a SQL Server stored procedure I need to run from within an excel spreadsheet, if that's possible. The stored procedure takes about three minutes to run, and the end result is 10 columns worth of data. Ideally, I'd like for those 10 columns to be my spreadsheet's 10 columns. Are there code snippets out there I can look at to learn: 1. how to connect to a SQL Server database via excel (hopefully using a DSN-less connection-- I have a connection string), and 2. how to call a SQL Stored procedure from Excel, and snag the resulting data. TIA, -Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locating and selecting Data from Worksheet | Excel Discussion (Misc queries) | |||
Selecting a row in a worksheet | Excel Worksheet Functions | |||
Selecting a specific worksheet | New Users to Excel | |||
selecting a worksheet | Excel Worksheet Functions | |||
Selecting a Worksheet Range | Excel Worksheet Functions |