View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuk Stuk is offline
external usenet poster
 
Posts: 1
Default SQL.REQUEST #N/A error

I have typed the following string into a cell in Excel
=SQL.REQUEST("DSN=Excel Files;DBQ=C:\Test SQL\test.xls", B1, 1, "Select * from sheet1", TRUE
The cell shows "#N/A". I am expecting it to return the values from the "Test" spreadsheet to the spreadsheet where I typed the sql command. What am I doing wrong

Also, is there somewhere to look for examples and tips on this command and sql syntax?