Skip to main content

Database connection session error


Forum|alt.badge.img+2

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

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+16
  • Most Valuable Pathfinder
  • 3274 replies
  • May 2, 2023

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


Forum|alt.badge.img+2
  • Author
  • Cadet | Tier 2
  • 1 reply
  • May 2, 2023

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”


Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+16
  • Most Valuable Pathfinder
  • 3274 replies
  • May 2, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings