Thread: Recordset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephan Kassanke Stephan Kassanke is offline
external usenet poster
 
Posts: 19
Default 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