SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Dec 2008
    Location
    Brussels
    Posts
    377
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post [Tutorial] Guestbook with Excel as database

    How to make a webbased guestbook with Excel as database.

    If you want to make a guestbook or other kind of messaging system for a web application, and you don't have a database available like MySQL with PHP or with ASP, then I have this nice solution for you.

    You can use Excel as a database it's not supposed to serve as database for a web application, but technically it is possible.
    So if your company ran out of budget or tools for a good database, read this page very carefully.

    Note: it is somehow buggy, it works only in IE in a Windows environment, and it does not work online because of browser securities. But it is a valuable solution for an intraweb or intranet.

    Here's the tutorial with Demo:
    http://www.bulevardi.be/?content=scr...&example=exvb2

    Some knowledge of Html, VBScript, Javascript and CSS is handy for this.

    I started building it first with a ADODB object and JET driver stuff etc... but every time I did a transaction to add or read something from the Excel file, I got a security popup that I couldn't get away. It was kind of annoying.

    So that's why I made it without these ADODB things....

    But the advantage with ADODB is that you can make queries from your excel file for generating nice output. Maybe someone has some ideas to make it better?

  2. #2
    Avid Logophile silver trophy
    ParkinT's Avatar
    Join Date
    May 2006
    Location
    Central Florida
    Posts
    2,284
    Mentioned
    181 Post(s)
    Tagged
    4 Thread(s)
    What a very clever (and ingenious) idea!

    As a way to skirt the troubles you described, do you think, with Javascript, you could read/write to a CSV file? Then Excel could read [import] it in order to generate reports.
    Don't be yourself. Be someone a little nicer. -Mignon McLaughlin, journalist and author (1913-1983)


    Literally, the best app for readers.
    Make Your P@ssw0rd Secure
    Leveraging SubDomains

  3. #3
    SitePoint Addict
    Join Date
    Dec 2008
    Location
    Brussels
    Posts
    377
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ParkinT View Post
    As a way to skirt the troubles you described, do you think, with Javascript, you could read/write to a CSV file? Then Excel could read [import] it in order to generate reports.
    I'm not sure about that... but with VBScript, you can immediately write into an excel file, so you don't have to import CSV files anymore.

    Quote Originally Posted by ParkinT View Post
    What a very clever (and ingenious) idea!
    I know it's totally the wrong way of making a guestbook...
    But at work, I had to make a webbased project (which was more complicated and had lots of different features) where I was not allowed to use any kind of good stuff like PHP/MySQL or normal webbased server/databases. My boss didn't allow me to install anything like that to make it work like a normal website.

    But somehow, I had to store data into some kind of database... I knew I could connect html with javascript, javascript with vbscript, vbscript with office applications. I tried with access, but it gave me lots of troubles and then finally with excel.

    So I ended up creating a messaging system for my management, so they can write messages for a whole team of users underneath them. The message system has several other features:
    - only titles of the messages are displayed, if you click, a jQuery animation opens the whole message
    - the titles are colored per theme
    - they can add multiple attachments (the files get copied from directory to directory with VBScript, not overwriting existing filenames)
    - they can edit every message afterwards, changing the attachments etc
    - they can delete every message on the same control panel
    - a search box to search through all messages, by theme, by content, by date, ...
    - ...
    And all that is stored into one simple excel worksheet.

    It gave me a headache programming this, with all the testing and errors... but since it's up and running from one year ago, it didn't have a downtime, yet.

  4. #4
    SitePoint Enthusiast Adrian98's Avatar
    Join Date
    Feb 2012
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up That's really much useful

    I needed the proper easy to follow help/guidance to use the excel as database. thanks to you and the tutorial is extremely helpful for me..


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
  •