Tranfering records from temp table to main table

  • Thread starter Thread starter filnigeria
  • Start date Start date
F

filnigeria

Please can anyone assist me

I would like to transfer records (whole feilds at once)from a temporary
table to the main table

i have a vba code that copies the records from an excel spread sheet and i
have even got the code that deletes the temporary tables after creation all
i need is a way to copy all the records off of them in to the main one
there are 14 different tables
the feilds names are not the same in the temp table and the main one

please can any one help me
 
Please can anyone assist me

I would like to transfer records (whole feilds at once)from a temporary
table to the main table

i have a vba code that copies the records from an excel spread sheet and i
have even got the code that deletes the temporary tables after creation all
i need is a way to copy all the records off of them in to the main one
there are 14 different tables
the feilds names are not the same in the temp table and the main one

please can any one help me
Click to expand...

An Append query is the solution to this problem.

Create a Query based on the temporary table. Change it to an Append
query using the query type icon. When prompted, select the name of the
temp table. There will now be a new row in the grid labeled "append
to" - under each field in the temp table select the name of the field
that you want loaded with that data.

Run the query using the ! icon and it will copy all the temp table
records (barring referential integrity or validation rule violations,
of course) into the target table.
 
Back
Top