Inserting Multiple values

[rajath]

Hi All,



I am trying to insert multiple records into datatable say TB1 at a time.I need to do this using single insert query. HOw can i do this.

thanks in advance

[Datagopherdan]

You can do this by creating an append query and setting criteria to filter just the information that you want added.