ADODB Connection Column Limit?

  • Thread starter Thread starter Dave
  • Start date Start date
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?
 
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
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Read of excel spreadsheet with ADO recordset 2
Need Clarification 1
Datatypes 1

Back
Top