Connecting VB.NET with Excel 2007 & Access 2007
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