Copy data from one table to another

[Antrac1t]

Dear guys,
would you mind to help me with copy data from one table to another? First table have data from acces database and this table load data by bindingsource (ez way). For this table i have filter something like this SeqMatBindingSource.Filter = "(Part_Group LIKE '" & hv_column_text.Text & "')". And now i need copy only few rows from this table to another. I can do it by for each but actualy i want to use SQL commnad.

Thank you guys

 

[JuggaloBrotha]

MS Access supports the Insert Into Select From type query: INSERT INTO Statement (Microsoft Access SQL)
Your query will be something like:

Insert Into DestinationTable
Select col1, col2, col3
From SourceTable
Where col1 = condition1 And col2 = condition2