Consulting

Results 1 to 4 of 4

Thread: Excel api and databases

  1. #1

    Excel api and databases

    I'm not sure if this is the right place to post my question, but here goes...

    I want to create an excel application that utilizes a backend database, but I'm not sure which one to use. It needs to be deployed easily on my client's computers. So far I've narrowed it down to MySQL and SQLite. Anyone have experience with these and excel api's? Thanks for your help,

    Gabe

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    moved to the sql forum. I think you will stand a better chance of getting specific help there....
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Why not just use Access? You can manipulate this from Excel, and no need of a license.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  4. #4
    VBAX Master CreganTur's Avatar
    Joined
    Jan 2008
    Location
    Greensboro, NC
    Posts
    1,676
    Location
    Depending on what you want to do, you can access the backend database by using ADO connections.
    -Randy Shea
    I'm a programmer, but I'm also pro-grammar!
    If your issue is resolved, please use Thread Tools to mark your thread as Solved!

    PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003


Posting Permissions

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