| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If then request | Excel Worksheet Functions | |||
| Request | Excel Discussion (Misc queries) | |||
| sql.request | Excel Discussion (Misc queries) | |||
| sql.request | Excel Worksheet Functions | |||
| Add-on to last request | Excel Programming | |||
Threaded Mode
