Often I receive records in Excel format that departments want converted into an Access database. One problem I often have is when trying to normalize, i.e. create a demographics table with just one set of demographic information per person, I need to be able to get rid of all the duplicate info for a person. I usually import the Excel data into a table first, and let it be autonumbered for the primary key. I then do a duplicate query to find the dups, however, from there I would like to be able to do a query and say if a person is in the table 5 times, with key fields matching for all 5 records, just show him once. Have tried Select Distinct, Unique Records, Unique Values queries, but since I am checking to make sure 3 key fields match across the records, I am having a problem. Maybe I am using the select distinct incorrectly? I will welcome any suggestions short of looking through manually, as there are a huge number of records. I'm sure others have this problem (additionally I have the first and last name together in the same cell problem, but that has been addressed in a different post, so thanks!), so this info would be immensely helpful!
Normalization from Excel Spreadsheet
- Thread starter belsha
- Start date
