#1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
teepee
 
Posts: n/a
Default sql.request


Does anyone have a comprehensible guide on how to use it that a dolt like me
can follow? Every time I try I get a #N/A.

The only guide I can find is at
http://www.bygsoftware.com/examples/...SqlRequest.zip but it's
really hard to follow.


  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
K Dales
 
Posts: n/a
Default sql.request

From the MSDN Library:
http://msdn.microsoft.com/archive/de...html/SEC41.asp

Not sure how familiar you are with ODBC; but if you are getting #N/A as a
result, it is usually because of problems either with the SQL syntax or the
connection string. There are a few examples of connection strings in the
reference above, but since these are dependent on the database driver used it
is not easy to give an all-encompassing guide on how to write the connection
string. Best thing I have found is to search the database developer's site
for "connection string" or do a generic net search for "Connection String"
with your db name, e.g. "Connection String Oracle"
--
- K Dales


"teepee" wrote:


Does anyone have a comprehensible guide on how to use it that a dolt like me
can follow? Every time I try I get a #N/A.

The only guide I can find is at
http://www.bygsoftware.com/examples/...SqlRequest.zip but it's
really hard to follow.



  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
teepee
 
Posts: n/a
Default sql.request


"K Dales" wrote in message
...
From the MSDN Library:

http://msdn.microsoft.com/archive/de...html/SEC41.asp

Many thanks

tp


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
using a file dsn in sql.request to connect to sql server Tricia Excel Worksheet Functions 0 July 20th 05 06:07 PM
SQL.REQUEST help needed mr.bungle Excel Worksheet Functions 2 April 28th 05 09:06 AM
Does SQL.REQUEST work in Excel X? mrl Excel Discussion (Misc queries) 5 February 4th 05 08:36 PM
installing sql.request help sql.request help Excel Worksheet Functions 0 December 15th 04 10:17 PM
sql.request Nikon Excel Worksheet Functions 1 November 10th 04 12:05 PM


All times are GMT +1. The time now is 09:54 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"