InfoPath Dev

Morning

Is it possible to create a 14 (rows) x 20 (columns) table, then populate all the fields, and hitting the submit button will have 14 rows written to your SQL database?

I know you can create a repeating table, but I want the repeating table to automatically open 14 rows, with different default values in 2 of the columns, fill out the form, and hit submit. I want to emulate a copy and paste actions from an Exel spreadsheet to a SQL database.

Any help would be appreciated.

 Yes, it should be possible. I've attached a screenshot showing the Default Values. I've set up 4 of my row, and therefore when I preview I get 4 rows automatically shown.

Good luck!