Excel as Database

ilarum

New Member
Hi Guys,

Kindly help me for proceeding the string connections in A2019 for using the Excel as Database.
 

Sachin_Kharmale

Active Member
Hi @ilarum ,
May be you need to use oledb

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

I hope it will help you..!
 
Top