Copying records from temp tables to main ones

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
 
Top