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?
|