How to read data from excel having 1000 colums using OLEDB.

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.
 

tmanasa19

New Member
Use Data-OLEDB Business object :
1. Set Connection --> Provide connection string Ex: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;Extended Properties="Excel 8.0;HDR=YES";
2. Open Connection
3. Then Use the Action "Get Collection" with the Query "select * from [Sheet1$]" output will be BP collection
4. Close Connection

Using these actions u can get the entire data from excel into BP collection
 

SriLakshmi

New Member
Nope this will not work as oledb has a limitation to return only first 255 columns and we already tried this approach.

This solution might work with more rows but not with more than 255 columns
 
Top