I need some help with a query. I have an Access database with two tables. I have an Excel spreadsheet with a number of columns of data that I need to import into 2 seperate tables in Access.<BR><BR>The Excel spreadsheet looks like this (column headers shown):<BR>ResponseID - Response 1 - Response 2 - Response 3<BR><BR>Now, what I need to do is import into the Access database each row of data as follows. ResponseID goes into table1. Then, each of the Response1, Response2, etc. from the SAME row need to go into table2. Also, each time a Response1/Response2/Response3 goes into table2 I need to also store the ResponseID with each record in table2.<BR><BR>Does this make any sense?