Results 1 to 2 of 2

Thread: integrating Excel with my program

  1. Feb 12th, 2001, 03:30 AM #1
    pochaco
    pochaco is offline

    Thread Starter
    New Member
    Join Date
    Feb 2001
    Location
    Philippines
    Posts
    1

    Question

    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.
    Reply With Quote Reply With Quote
  2. Feb 12th, 2001, 04:03 PM #2
    PsudoLogical
    PsudoLogical is offline
    Addicted Member PsudoLogical's Avatar
    Join Date
    Dec 2000
    Location
    Upstate N.Y.
    Posts
    144
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width