Copying records with vb

[locutus]

hi, i need some help as me and vb are not brill, so here goes:

i need to copy selected fields out of one access file and place them in another table in another file, the way i thought of doing it was to link the tables all in to one file and the write some code to copy these rows out of one table and paste them into another, but i cant work out the code needed to do it?

anyway thats it, so any help would be much apreciated.

cheers

 

[BukHix]

You could do it by grabbing, copying and then pasting a recordset from one table to another. This should get you started.

Topic: Using RecordSet to update table?

In that example I am using static data but it could be modified pretty easily to accomplish your goal.

 

[locutus]

thanks for that, i got that to work but that replaces all the fields in the new table, what i need it to do is add new fields to the end of the table.

is it possible to use variables and read data into them so i can validate it, and then insert it to the new table? if so how?

cheers again

 

[locutus]

ignore last message posted to the wrong topic

later