Database connection session error

  • 28 April 2023
  • 3 replies
  • 23 views

Badge +1

I am trying with different sessions name while using Database command but it showing name already exist please try with different session name. Please help me regarding these.

 

Can any one tell me excel connection string for .xls file


3 replies

Userlevel 4
Badge +8

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";

Badge +1

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”

Userlevel 4
Badge +8

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

Reply