0

The below connection string establishes connection with excel file which has extension as '.xls' but same string throws an exception while opening a connection with file which has extension as .xlsx.

Any idea?

ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\abcd\Desktop\demo.xls; Extended Properties=excel 8.0; Persist Security Info=False

Community
  • 1
  • 1
NewAutoUser
  • 533
  • 2
  • 10
  • 26

1 Answers1

1

This is because you need a different connection string for xlsx'es.

GSerg
  • 76,472
  • 17
  • 159
  • 346