Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset
Andrew Haycock wrote:
How do i increse the size of a recordset. i get an error saying that my sql query has to many columns? Am i looking in the correct place? Hi Andrew, the "size" of the recordset indicates the number of rows for me. If the error states, that you have too many columns in your query, i would suggest to decrease the number of columns. Use something like Select ID, Name, Whatever other column ... FROM instead of Select * FROM or redesign your database tables. best regards, Stephan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
query a recordset | Excel Discussion (Misc queries) | |||
return recordset | Excel Discussion (Misc queries) | |||
Looping Through A Recordset | Excel Programming | |||
Looping Through A Recordset | Excel Programming | |||
ADODB Recordset | Excel Programming |