Since Access stopped having email data collection, I tried using Google forms to collect our school's students schedule. The forms work very well to ask and collect the data, but I am having a hard time importing the data into my Access database tables. Though Google forms provides a spreadsheet with the data, I can't match the spreadsheet's rows and columns with my table's fields...help!

---

Reply from Alex Hedley:

You could import the data into a temp table then run a query to insert that data into your pre-existing table.