SQL.REQUEST #VALUE and #N/A errors, would like some advice please.

J

jnavarre

Hello!

I am currently working with SQL.REQUEST and have run into a brick wall. I
have installed the add-in, and am trying to use it to pull information based
on a value in an existing spreadsheet, and for some reason it keeps giving me
#VALUE errors. I would really appreciate any help you could offer me on
this, thank you in advance!

Here is the formula I am using, is there something wrong with it?

=SQL.REQUEST("DSN=xxx;UID=xxx;PWD=xxx;Database=xxx","SELECT 'Course Status'
FROM 'Course Detail View' WHERE ('Course Detail View'.'Course
Code'='"&$A9&"')")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sql.request question 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Macro to insert a line when a value changes in a range 1
SQL.REQUEST #N/A error 5
#N/A Using SQL.REQUEST 3
Vlookup N/A# error and VALUE# error 4
Pass-Through ODBC query *to* (not from) MS Access 4
Formula for classification system 0

Top