-
I'm starting on a program that needs to integrate MS Excel. The probem is, I don't know where to start. My boss says that the Excel file should serve as the database source. How will I do this? Basically, how do I open, use, edit, delete, and add details to the already existing excel file? Thanks in advance to whoever is going to reply to this.
P.S.
My boss is giving me a maximum of 120 hours to do this project so I really hope that someone would send me a reply as soon as possible.
-
The place to start is to create and ODBC connection to your spreadsheet, using the Microsoft Excel Driver. After that you will need to open the data source in VB as you would any other recordset... As I have few other details on what you are trying to do...PM me if I can be of further help
Good Luck
