Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data from one file to another
Hi Rock
I think that you need a macro for this. you need to give specifific details of the fields (column Headings) in db2 and the same for db1. Then the macro can decide which fields are to be copied. Start a new post with this information. HTH Peter "rock" wrote: Hi, I have Excel 2002 and have one file with fields from db1 which I wish to populate into another file for db2. The problem is that whilst most of these fields are the same (Fname,LName,Email etc), they are in different columns or there are a few that do not exist in the new db2. Another problem is that there are 6000 of them! I have thought that maybe I can bring them into db2 using copy/past for individual columns and place them where they should go in the new db2. The extra columns I will have to leave in db1 as there is no place for them in db2. Thing is, how do I paste these really long columns into the new dbase. Then again maybe there is a better way. Thanks, rock |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to pull data from another file - update name of file | Excel Discussion (Misc queries) | |||
How do I merge two excel file data (no changes made to the file)? | Excel Discussion (Misc queries) | |||
Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
How do I convert an Excel file to a Phonebook Data File? | Excel Discussion (Misc queries) | |||
To get client data from a saved file back to the master file | Excel Discussion (Misc queries) |