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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
List all tables, including document structure 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Mail Merge skipping records/sending one at a time 0
How to paste this down? 3
Copy old subform records to new Form's subform 1
Copy previous record into form field 0

Top