Hi Guys,
I'm hoping someone here can help me with a "Fuzzy Matching" solution to my problem. I'm designing a Media Database. The source for my data is a data dump from iTunes imported into an Access table named Music. This table contains raw data that has not been scrubbed. The Name field contains the song title. Scrubbed song titles are contained in a lookup table named lkpSongTitle in the field named Description. These titles are similar but not exact matches. I have been able to match up a lot of them but there are still about 250 records that don't match up. The manual process I'm using is starting to wear my nerves thin. I would like to create a query that shows the unmatched title names from the Music table and then display the record from the lookup table that is the mostly likely match for that song title. Is this possible? I would appreciate any help you can provide. Thanks In Advance.
I'm hoping someone here can help me with a "Fuzzy Matching" solution to my problem. I'm designing a Media Database. The source for my data is a data dump from iTunes imported into an Access table named Music. This table contains raw data that has not been scrubbed. The Name field contains the song title. Scrubbed song titles are contained in a lookup table named lkpSongTitle in the field named Description. These titles are similar but not exact matches. I have been able to match up a lot of them but there are still about 250 records that don't match up. The manual process I'm using is starting to wear my nerves thin. I would like to create a query that shows the unmatched title names from the Music table and then display the record from the lookup table that is the mostly likely match for that song title. Is this possible? I would appreciate any help you can provide. Thanks In Advance.
