Amy, This data is downloaded from a company that provides fee/subscription based information about manufacturing companies. We are trying to build an industry based database for marketing to use. I am trying to programatically narrow down the list. The rest will have to be manually linked.
Thanks. Steve ________________________________ From: [EMAIL PROTECTED] on behalf of Amy Cook Sent: Tue 11/2/2004 4:36 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] merging data - fuzzy keys Wow...do you ever have overlap? A bill-to and ship-to with the same name, and in the same city....but different customer numbers in your production database? What if someone spelled something wrong or with a different abbreviation in your excel db than your production? If you had the key to your customer master, it'd be easy...write a little upload utility from a flat file, or an update query using odbc. Any chance you can get that to add to your excel db? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Kunzman Sent: Tuesday, November 02, 2004 2:25 PM To: [EMAIL PROTECTED] Subject: [U2][UD] merging data - fuzzy keys I am working on a project to populate industry information (SIC, NAICS, etc.) into my customer database from a different database (excel). The only thing somewhat in common is the customer name, city, and state. By using these common data elements, I have limited success with SOUNDEX. Is there some other tool/utility I could use to help me merge this data? Unidata 6.0 HP9000 RP5470/ HPUX 11.11 Thanks in advance. Steve ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/