Results 1 to 6 of 6
  1. #1
    Join Date
    May 2008

    Unanswered: advice needed please on suitable database

    Hi all
    I need a relational database with a search interface that acts rather like a website.Let me try explain.
    I have 100 buildings which are at present on a excel spreadsheet.

    I would like to be able to create a simple `home page' property index for the buildings.

    From this index I would like to have a link to a seperate page for each of the 100 buildings

    Each property page will have a description (preferably with a picture) and various other bits of text.
    (All of these pages will be identical in format and composition.)

    From each of the property description pages I would like to create links to 4 further seperate pages each with its own topic heading ie roof,walls, drains etc

    These pages could be excel spreadsheets

    Its a bit like a simple website but on a pc .Could a website format ,say publisher or frontpage be used offline ?
    Any ideas would be very welcome thankyou

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    well if you want a web style interface, whats stopping you running a webserver on your PC and hosting your own website?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2008
    mmmmmmmm at first I thought that wouldn't be practical but the more I think about it the more I think it may be possible to use a website. Only problem is some of the info pages are excel sheets which need to be interrogated and updated daily. It would mean uploading countless spreadsheets daily

    Can I link to a live excell spreadsheet on a pc from a website ?

  4. #4
    Join Date
    Jan 2007
    Provided Answers: 12
    Why are you relying on Excel?
    Home | Blog

  5. #5
    Join Date
    May 2008
    I am using excel to log and monitor remedial work and weekly/monthly invoicing data about 100 properties. There are numerous topics of data and all of it has a £financial value which formulae update .
    There are several of these A3 spreadsheets
    I was wondering if I could use excel for this database. I can insert images but could I also insert links into a spreadsheet to other workbooks ?

  6. #6
    Join Date
    Nov 2007
    Adelaide, South Australia
    Quote Originally Posted by peanut
    I was wondering if I could use excel for this database.
    Definitely not recommended, but you can. Thing is that Excel is a spreadsheet, not a database, so you'll have problems if you do.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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