VBA - Insert a record from one table to other

[Praveenevg]

Hello,
Fairly new to VBA coding.

In my VBA code, i am trying to move some table records from table1 to table2. Both table1 and table2 has exact structures.

In the INSERT statement for table2, what is the easy way to insert a record from table1? I am trying to avoid having to specify each field name in the INSERT statement. Because, i have 100 fields in table.


Is there a way to INSERT a particular record from table1 to table2 without having to specify field names in the INSERT statement like in below example?

INSERT INTO Employees " _


& "(FirstName,LastName, Title) VALUES " _
& "('Harry', 'Washington', 'Trainee');"

[June7]

Why do you need to do this?

This syntax works for me:
INSERT INTO [tablename] SELECT * FROM [tablename] WHERE ID=someID