ExcelBanter - ADODB Connection Column Limit?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ADODB Connection Column Limit? (https://www.excelbanter.com/excel-programming/418918-adodb-connection-column-limit.html)

Dave

ADODB Connection Column Limit?

I'm using an ADODB connection in VBA to read a flat csv file, however I'm
running into the 255 column limit, is there a way around this?

joel

ADODB Connection Column Limit?

If you have more than 255 columns then you either have to put the data in
more than one row or put the data into more the one worksheet.

"Dave" wrote:

I'm using an ADODB connection in VBA to read a flat csv file, however I'm
running into the 255 column limit, is there a way around this?

All times are GMT +1. The time now is 02:25 PM.