2007 - Office System Driver Data Connectivity Components Link ((top))

string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Data\Sales.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=YES;""";

| File Extension | Format | Read | Write | |----------------|--------|------|-------| | .accdb | Access 2007 database | Yes | Yes | | .xlsx | Excel 2007+ workbook | Yes | Yes | | .xlsb | Excel binary workbook | Yes | Yes | | .xlsm | Excel macro-enabled workbook | Yes | Yes | | .xls | Excel 97-2003 (via ISAM) | Yes | Limited | | .mdb | Access 97-2003 (via Jet) | Yes | Yes | | .csv , .txt | Text/CSV (via Text ISAM) | Yes | Yes | 2007 office system driver data connectivity components link