SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Hybrid View

  1. #1
    SitePoint Member gibo's Avatar
    Join Date
    Feb 2003
    Location
    Cape Town
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    easy question concerning VBA for excel

    I want to have a form where the user enters the data and on the submit action, this info should be updated to a spreadsheet. How do i do this???

  2. #2
    SitePoint Wizard swdev's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    1,053
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You have not given enough information to answer this question.

    Anyway, this is the database forum

    What is processing the form? PHP, ASP, something else?

    It may be as simple as writing to / updating a csv file that can be opened by your spreadsheet program.

    Definitley more information required

  3. #3
    SitePoint Member
    Join Date
    Jan 2005
    Location
    Phoenix
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Wink

    Out of curiosity, isn't an Excel spreadsheet simply a flatfile database?

  4. #4
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, it is, and no, it isn't.

    Excel adds all kinds of feature and functions on top of a file format for storing data. Each sheet can be used as a flatfile table.

    And if you see each worksheet in the workbook as corresponding to a table, then it is more correct to say Excel workbooks can be used as an ISAM database. It has no relational capability, but then nor does MySQL.

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by asterix
    It has no relational capability, but then nor does MySQL.
    troll alert!!!

    please, let's leave this type of comment for the folks at dbdebumph.com

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    eh? what's the problem today?

  7. #7
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK, maybe I did understate things a little


Bookmarks

Posting Permissions

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