SriLakshmi
New Member
Hi all,
We have a requirement to read data from excel having 1001 colums.
Due to large excel data (7k rows and1001 cols) we are using oledb to retrieve only filtered records into bp collection (max of 10 records) but as OLEDB has a limitation of getting only first 255 cols.
Request you to kindly let know how can i get all 1000 cols with a single select query into my bp collection.
Awaiting updates ASAP.
ThankYou.
We have a requirement to read data from excel having 1001 colums.
Due to large excel data (7k rows and1001 cols) we are using oledb to retrieve only filtered records into bp collection (max of 10 records) but as OLEDB has a limitation of getting only first 255 cols.
Request you to kindly let know how can i get all 1000 cols with a single select query into my bp collection.
Awaiting updates ASAP.
ThankYou.