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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.