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

D

Deepa

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 Col’n 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer Date from Access- Excel 0
Getting data out from Excel File into PowerPoint (Linked in) 1
Data from Pivot Table 3
Excel Data Transfer Issue (strange situation) 1
Transfering data/table from excell to access 1
Excel To Access: Transfer multiple rows from excel to access 1
Excel To Access: Transfer multiple rows from excel at the same tim 2
Excel To Access: Help with getting a range data from excel to acce 0

Top