xl database for asp page

  • hi techies

    i have 3 ASP pages using excel as database.

    now i have to set primary key for excel database. is it possible.

    the need is
    the page shouldnt allow any entry for a particular date(july 01)of every year inside excel database

    the pages only do select and insert into the database

    kindest possible regards

  • Re: xl database for asp page


    A "PRIMARY KEY" concept is a database concept. It is not something that excel is set up to do ( FAIK ).

    Essentially, if you continue with the use of excel as the database you will need to write your update queries so that YOU are in command of what happens. My suggestion is to, at a minimum, transfer to a true relational database like Access.