Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DPL
 
Posts: n/a
Default How do I run a SQL query against a MS SQL Server database from exc

How do I run a SQL query against a MS SQL Server database from within Excel
2002? I know it can be done somehow using the SQL.Request addin function.
However my attempts using this function have continually failed. Can some
one please provide a working example to the pubs or Northwind dbs that I can
work with and use to help debug my attempt? Thank you!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Database Query String Too Long Karl Burrows Excel Discussion (Misc queries) 4 January 27th 05 06:25 AM
Query a Access database that has a module from Excel Oggie Excel Discussion (Misc queries) 1 January 4th 05 08:43 AM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
query problem after changing to SQL server Margaret Excel Discussion (Misc queries) 1 December 13th 04 11:23 AM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"