Create Table SQL
Create table
CREATE TABLE tblFormResponsesFinal( txtFirstName varchar(50), txtLastName varchar(50), txtEmail varchar(50), chkShire tinyint(1), chkMinasTirith tinyint(1), chkMirkwood tinyint(1), chkLothlorien tinyint(1), txtAreaInfo textarea )Insert example values
INSERT INTO tblFormResponsesFinal (txtFirstName, txtLastName, txtEmail, chkShire, chkMinasTirith, chkMirkwood, chkLothlorien, txtAreaInfo) VALUES ('Frodo', 'Baggins', 'frodobaggins@theshire.net', 1, 0, 1, 1, 'I\'m travelling with valuable jewelry'), ('Gandalf', 'the Gray', 'gandalf@valinor.gov', 1, 1, 1, 0, 'A wizard is never late, nor is he early, he arrives precisely when he means to'), ('Smeagol', 'Gollum', 'gollum@mistymountains.com', 0, 0, 1, 0, 'Stupid fat hobbits'), ('Boromir', 'Hurin', 'boromir@gondor.gov', 0, 1, 0, 0, 'go to minas tirith and save my people'), ('Samwise', 'Gamgee', 1, 0, 1, 1, 'Boil em, mash em, stick em in a stew')