Data from one file to another

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

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