ADODB Connection Column Limit?

D

Dave

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?
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QueryTables, some basic questions 5
64-bit ADODB in Excel 4
Check if ADO connection open 2
ADODB over HTTP? 3
Read of excel spreadsheet with ADO recordset 2
ADODB Create New Database from Excel 2
Need Clarification 1
Cell widths when filling a cell using ADO 2

Top