insert mutiple rows

[Irfan]

hi,

I tried to google 'sql to insert multiple row MSaccess' but coudnt get a
proper link.

This is roughly what i want to do.
..
I have Material, Load & filename as Columns in a table.All i want to do is
copy all the rows having filename as 'x' in the same table.

any help is appreciated
TIA
irfan

 

[Irfan]

thanks, i have sorted it out.
It was simply appending the rows.

INSERT INTO tblName(r1,r2..)
SELECT tblName.r1,tblName.r2...
FROM tblName
WHERE ....