Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Harrisburg, PA

    Unanswered: Update a table with info from Excel spreadsheet

    This is my first thread, so please forgive me if this doesn't look right.....

    Anyway, I have a table in Access with Yes/No fields (as well as other various data fields) and I would like to update existing records in this table with an Excel spreadsheet, of which I have linked to this database. Both table and spreadsheet contain identical field names. I am able to match up the records in the table to the records in the spreadsheet. But my problem is that I'm trying to update the Yes/No fields in the table with info in the spreadsheet - if the spreadsheet contains an "X", indicate the Yes/No field in the table as "checked".

    Any help would be appreciated........thanks!

  2. #2
    Join Date
    Jul 2004
    Use true or false for you yes no boxes


Posting Permissions

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