The data adapter cannot be configured for tables that have more than 100 columns.

[CharlieChau]

I use the OleDbDataAdapter->microsoft jet 4.0 OLE DB provider->use SQL statements-> Query Builder to select the columns in my table. But I have 150 columns, after select all columns option. I have the message:

"The data adapter cannot be configured for tables that have more than 100 columns."

How can I increase the number of the columns of VB . NET or do it different way to run my Query?

Thanks,
CC.

 

[CharlieChau]

I even splited the table into two small tables of 75 each and join them. But I still have the error 100 columns.