#1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 27
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
external usenet poster
 
Posts: 1,163
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
external usenet poster
 
Posts: 27
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
If then request bpc Excel Worksheet Functions 1 September 22nd 09 06:35 PM
SQL.REQUEST SQL.REQUEST Excel Discussion (Misc queries) 0 November 12th 07 02:34 AM
#N/A Using SQL.REQUEST Mike Brown Excel Programming 3 June 7th 04 05:05 PM
2nd request Christy[_2_] Excel Programming 0 October 1st 03 01:32 AM
sql.request Ivan Belal Excel Programming 1 September 18th 03 08:24 PM


All times are GMT +1. The time now is 01:52 PM.

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

About Us

"It's about Microsoft Excel"