Search results

  1. B

    Merging table with no IDs into table with IDs

    This is a membership organization that started small. It went from tracking member attendance on paper to tracking via Excel. Every week for over forty months new members were added to the spreadsheets (but never removed). The only unique field in each record was Member Fullnmame (no MemberID)...
  2. B

    Merging table with no IDs into table with IDs

    Shameless bump for the Monday crowd. :)
  3. B

    Merging table with no IDs into table with IDs

    Thanks for the suggestion, Sir. The problem with C&P is that the process has to be repeated almost 40 times --- once for each previous Excel monthly file that I'm trying to import. And each Excel file has a different list of members (50 or so new members added each month). Here's the two file...
  4. B

    Merging table with no IDs into table with IDs

    Greetings, n00b here. I've inherited an Excel data system with innumerable record duplicates from one (monthly) file to another. To complete my transformation to an Access mdb, I need to grab attendance data for members from past months' Excel files and merge that data with the new Access file...
Back
Top Bottom