| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data from Access into Excel | Excel Discussion (Misc queries) | |||
| How do I prevent data truncation from access to excel using MS Qu. | Excel Worksheet Functions | |||
| How do I transfer data from Notepad to Excel? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Linear Mode
