Database connection session error

Hi @GuruLokesh92 

excel connection string for .xls file

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;Extended Properties="Excel 8.0;HDR=YES";

Hi @Tamil Arasu10 

Thank you for your replay.

I tried above Connection string getting error “Could not connect to Database. Could not find installable ISAM”

Hi @GuruLokesh92 ,

 follow these steps:

1. Open the Excel workbook.

2. On the Data ribbon, click the Connections button.

3. In the Workbook Connections dialog box, select the connection to the Access database, and then click Properties.

4. In the Connection Properties dialog box, click the Definition tab.

5. Delete the following parameters from the connection string:

   Jet OLEDB:Bypass UserInfo Validation=False;
   Jet OLEDB:Limited DB Caching=False;
   Jet OLEDB:Bypass ChoiceField Validation=False

6. In the Connection Properties dialog box, click OK. At this point your data should be refreshed.

7. In the Workbook Connections dialog box, click Close, and then save the updated workbook