Consulting

Results 1 to 3 of 3

Thread: Excel to SQL

  1. #1

    Excel to SQL

    I've written a mini system in excel that people are using to record results via a userform.

    This mini system was only meant for a small group of users, but other departments have started to adopt it.

    I don't have the programming knowledge to develop an html user interface at the moment, but I would like to get this data onto an SQL database, rather than sitting on an excel spreadsheet.

    Can I put some code in the excel macro that when the button is pressed, it sents the data to SQL as well?


    I have pulled information from a database before using VarSQL = "SELECT......

    Any ideas?

  2. #2
    VBAX Newbie
    Joined
    May 2009
    Posts
    3
    Location
    Hi, search for the post:
    "This is how to write into SQL db table using excel VBA" by v.vasquezsj, submitted 07-23-2008
    in this forum (sorry, can't post the link).
    Maybe this could get you started?

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    You can connect to the database as you do now and issue SQL Insert or Update statements.
    ____________________________________________
    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

Posting Permissions

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