Updating a Table with an autonumber

[skelleex]

I have a table that I want to insert many rows of information into however it has anautonumber as the primary key. How can I insert 3 columns of data and 20 rows of information into this table in using sql.

Thank you

[r937]

INSERT
  INTO daTable
     ( column9
     , column3
     , column7 )
VALUES
  ( 'asdf' , 'qwer' , 4567 )
, ( 'fghj' , 'tyui' , 5678 )
, ...
, ( 'vbnm' , 'ghjk' , 0937 )

[skelleex]

thanks