ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Recordset (https://www.excelbanter.com/excel-programming/276616-re-recordset.html)

Stephan Kassanke

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




All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com