Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Troy Tempest
Starting Member
1 Post |
 Posted - 2008-12-09 : 08:18:50
|
| Hello,I'm a complete beginner with SQL so this is probably totally trivial.I have an excel file I want to read certain column entries for. First I bind the column of interest:SQLBindCol (StmtHndl, 3, SQL_F_CHAR, ELECTRICITY, f90SQL_NULL_PTR, iRet)Then I use a fetch command to recover the entry for each rowSQLFetch(StmtHndl,iRet) This reults in the following error: 22002 Indicator variable required but not supplied on column number 3 (ELECTRICITY).I have been banging my head off this particular brick wall for the last 4 days. I have absolutely no problem interfacing with a database file (.mdb), but for some reason Excel is a problem. Am I missing something?TT |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 09:32:13
|
| cant you use OPENROWSET?http://msdn.microsoft.com/en-us/library/aa276850(SQL.80).aspx |
 |
|
|
|
|
|
problems executing simple SQL fetch routine