Sorry Friend ,

In my last post i think i have given you the steps for inserting data from any file into any table .

But now i realise that that is worthless for you . Now for your post

how can i insert more that one row with query

so Now use this simple query .

Insert into table [Table Name]

Select [Col1,Col2,Col3,Col4....etc] from [Table Name]

Use This Query