Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a file dsn in sql.request to connect to sql server | Excel Worksheet Functions | |||
SQL.REQUEST help needed | Excel Worksheet Functions | |||
Does SQL.REQUEST work in Excel X? | Excel Discussion (Misc queries) | |||
installing sql.request help | Excel Worksheet Functions | |||
sql.request | Excel Worksheet Functions |