Sunday, January 18, 2009

Connect To Office 2007(Access 2007 , Excel 2007) Without Installing Entire Office 2007

Deploy application that use office 2007 ( Access 2007 , Excel 2007) and end user machine does not have Office installed on machine. In this case it is not necessary that end user machine must have office 2007 installed on machine.

Just install Data Connectivity driver.
2007 Office System Driver: Data Connectivity Components

Office 2007 Data Connectivity driver

  • ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”

  • ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

Driver is around 25mb so it can reduce overhead of office 2007.

No comments: