Could you kindly assist with following.
I presently have records stored in Excel and would like to know how I could transfer these records into Access and also normalise into tables and also remove duplicates.
given below typical Excel records
Company name, tel, fax, SIC sector
A company may operate in several sectors, i.e clothing
ACME, tel, fax, clothing womens
ACME, tel, fax, clothing mens
ACME, tel, fax, clothing childrens
ACME, tel, fax, clothing sporting
ACME, tel, fax, clothing hosiery
I would like to get to
ACME, tel, fax, clothing womens
clothing mens
clothing childrens
clothing sporting
clothing hosiery
the company name (same tel & fax) in a record at times is duplicated, but what differs is the sector.
I would like to retain the company name (once), but not remove the differing sectors it operates in.
I have mangaged to remove duplicates, but the solution is partial and inadequate, since it keeps the first record it meets, but removes subsequent sectors.
i.e.
ACME, tel, fax, clothing womens
any assistance?
thanking you in advance
I presently have records stored in Excel and would like to know how I could transfer these records into Access and also normalise into tables and also remove duplicates.
given below typical Excel records
Company name, tel, fax, SIC sector
A company may operate in several sectors, i.e clothing
ACME, tel, fax, clothing womens
ACME, tel, fax, clothing mens
ACME, tel, fax, clothing childrens
ACME, tel, fax, clothing sporting
ACME, tel, fax, clothing hosiery
I would like to get to
ACME, tel, fax, clothing womens
clothing mens
clothing childrens
clothing sporting
clothing hosiery
the company name (same tel & fax) in a record at times is duplicated, but what differs is the sector.
I would like to retain the company name (once), but not remove the differing sectors it operates in.
I have mangaged to remove duplicates, but the solution is partial and inadequate, since it keeps the first record it meets, but removes subsequent sectors.
i.e.
ACME, tel, fax, clothing womens
any assistance?
thanking you in advance