data transfer from Excel to Access but the new table stru is diff
 

How I can transfer data from Excel to Acess or Dbase or in SQL Server
2000,when the table structure ia not the same.
The data in Excel or in txt format is like

Hair Care

Company: irfjneifnmkef
Add: nfoidgfd
Ijfiojfpfs
Dsfddsgf
Phone: 00000
Fax: 000000
Email: trtgrg@mklbf
Website: vnjdnvdv.com

Company:tyithtgmh
€¦€¦€¦
€¦..
€¦.
Same for the 8 times then Activity change

Skin Care

Company: ughoiufjgpfdm
€¦€¦€¦€¦€¦..
€¦€¦€¦€¦€¦..

Again same type of data 8 times, maximum


What we need is to design a table in Access or SQL Server 2000 and fields
should be


Activity Company Add1 Add2 Add3 Phone Fax Email website
€¦€¦.. €¦€¦.. €¦€¦.. €¦€¦. €¦€¦. €¦€¦.. €¦€¦. €¦€¦. €¦€¦€¦


We need HairCare, Skin Care under the Activity Coln and so on?
Can u tell me how we can do this.I know simple data conversion but table
structure should be same and here we need a diff structure with that data.

Please help me if u can.