opening an .xlsx file gives an error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • user1980
    New Member
    • Dec 2009
    • 112

    opening an .xlsx file gives an error

    hello..

    i am developing a page in asp to open an .xlsx file and display its contents..
    i have used this connection string
    Code:
     sConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""Modified.xlsx"";Extended Properties=""Excel 12.0;HDR=NO;IMEX=1"""
    .

    i get an error...ADODB.C onnection error '800a0e7a'

    Provider cannot be found. It may not be properly installed.

    do i have to install any dll on the server for opening .xlsx..

    thank you for your time.....
Working...