How can i move specific record from one table to another table?

Question

I've created delphi6 programs connected to a MS access database. it has 2 tables(not a master-detail), 1 has 5 fields and the other has 7 fields. they have 4 fields in common. all i want to know is how, using sql or something, to move a specific record from 1 table to another. im using ADO approach displaying the database (both tables) in dbgrid.

Answer 1

I know nothing whatsoever about delphi but here is the gist of the sql. Assume your primary key is numbered and you are looking at record 10
$variable1 = SELECT Field1 FROM MyTable WHERE PrimaryKey = 1
$variable2 = .... etc
Then assuming these are the first 4 fields run this
INSERT INTO MyTable Values($variable1, $variable2, $variable3, $variable4, '', '', '');

Hope this helps

Answer 2

Assuming both tables are in the access database (the MDB file), execute the following statements:

insert into TableA select from TableB where
delete form TableB

Answer 3

Simple SQL command to copy the data!
this will work!

Answer 4

Try drag and drop.

If not given that option, open file, then edit, then view, then tools.

look for this control, if you do not find it open help.