P M

P M

  • NA
  • 1
  • 0

Connecting VB.NET with Excel 2007 & Access 2007

Oct 9 2009 1:47 PM
Hello All I am starter programmer with VB.NET My client project requires me to make an app to connect with Access 2007 database and populate some Excel files with it. I have been struggling on that for past few days. The issues I am facing are : 1. I am running the program in x86. However, at the clients end, they want to run in some comps who may not have Office 07. Will there be any driver issues ? I am making the OLEdbconnection provider as Provider=Microsoft.ACE.OLEDB.12.0 2. I am Importing References Microsoft Object Excel Lib 5.0 Do I need to add any other reference to avoid any run time errors on dll in the release ? Also, I have to make Excel files as 97 acceptable, how to do that ? 3. While testing on my other system which do not have Office 07, I am getting this error at runtime: Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) Is this any issue related to the driver properties ? Will really appreciate any answers by you guys. Thank You NovSaggi