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

64-bit ADODB in Excel 4
QueryTables, some basic questions 5
Check if ADO connection open 2
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Using ADODB Efficiently 1
ADODB Create New Database from Excel 2
Excel error connecting to sqlserver using ADODB, but can thru Datamenu 0
ADODB over HTTP? 3

Top