Results 1 to 4 of 4
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Using SQL Server for Excel Forms (VBA/Excel/2003)

    I am exploring the possibilities before I tell my customer that I can do the latest thing they have asked for.

    <img src=/S/question.gif border=0 alt=question width=15 height=15> Is it feasible to use queries to SQL Server to populate my ComboBox lists in an application built with Excel VBA?

    Right now, I have lots of lookup lists on a sheet in my Excel workbook. I would like to place the lookups in an external location so that I do not have to touvh the Excel file to change a list. {I prototyped with a customer list of 10 entries, rather than the complete 200}.

    The next phase of the project is to write to the SQL Server with the results.
    Alan

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using SQL Server for Excel Forms (VBA/Excel/2003)

    You should be able to do that, using ADO from within VBA. I have only experience extracting data from Access databases, so I can be of little help with the SQL Server part of your question.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using SQL Server for Excel Forms (VBA/Excel/2003)

    It certainly is feasible to do - ADO or DAO with ODBC drivers are the two basic options. One caveat - you users will need to have permissions to do whatever it is you wish with the data, and that may involve negotiation with your SQL Server database administrator. On the other hand, if you will be setting up your own MSDE or SQL Server then you will have a significant learning curve as you build your own database. It has many similarities to Access, but also some substantial differences in the administrative area.
    Wendell

  4. #4
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Using SQL Server for Excel Forms (VBA/Excel/2003)

    I went back and told my client that I still want to do it but will not charge them for my experiments. Once I figure out how to do it all, I should be THE expert.

    Been doing some reading and should be able to give our readers an update in a few weeks.
    Alan

Posting Permissions

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