SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jul 2011
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Excel to Access DB Classic ASP Unique Records

    We have an internal application that requires the user to upload an excel file to existing access database daily (replace the ones in the access file based on a unique id column in excel and access). this way the data being uploaded to access will be new (from the excel file). The user should be able to upload the file using a browse button. I have successfully completed the part of adding data to the access db but am not able to find out a way to add only unique entries.

    Another way to do this is to delete all the entries in the access database that are in the excel and then add the new ones.

    not sure how to proceed. please help.

  2. #2
    SitePoint Member
    Join Date
    Jul 2011
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    "SELECT" the data from the Excel Spreadsheet and do an "UPDATE" based on the Unique ID.
    In your ASP code set
    "On Error Resume Next"
    so that the errors generated by any missing ids will be skipped.


Tags for this Thread

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
  •