Click here to Skip to main content
15,614,766 members
Please Sign up or sign in to vote.
5.00/5 (2 votes)
See more:

Looking for the correct connection string format to use
to connect to an excel spreadsheet.

Current code is below:
String sConnectionString = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\andrew.c\\Documents\\Leave.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES"; 


Andrew C
Updated 8-Apr-16 1:19am
[no name] 4-Dec-11 20:42pm    
EDIT: added "pre" tag
rchacko 18-Nov-13 4:05am    
When I try to read an excel 2010 file, got an error:
Could not find installable ISAM

Any idea?

1 solution

Here are lists of Connection strings for Excel[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900