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
    Youtham

  • Re: xl database for asp page


    youtham,


    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.