could anyone assist - removing duplicate records?

[990405]

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

 

[SydneyGeek]

You have an issue with data normalisation. Too big to deal with in detail here, but the MS KNowledge Base has a helpful download.
Enter "Understanding Relational Database Design" (without the quotes) and download the version for your version of Access. It's a Word file (with screenshots) showing how the table structure for the Norhtwind database was derived.

Denis