Importing Exporting Data

[hinser13]

I have two different databases and would like to import data from one database into the other.

The Clients table in one database (database1) has different field names in the other client table (database2)

I want to import all the client data from database 1 and currently can only think of exporting the data from database 1 as a xls spread sheet, changing all the column headers to match field names in the table, located in database 2 and then importing the spread sheet into database 2, but what a pain.

Is there an easier way to import data from one database table into another with different field names?

Thanks mark

 

[boblarson]

Is this going to be a recurring task? If so you could import to a transition table which would be set up for the incoming data and then you could use one, or a series of, append query/queries to move the data to the actual table/tables you want the data in .