So I am importing some excel files into the access database, the problem here is the format. For example in excel I would have a question that would say Who are the presidents of US - Washington - Adams the answers would be in bullet form, when I imported the file into access the two separated bullet points split up into two different rows instead of staying in one cell. So I would have a row with one line of response but without a question. So this is what I am doing right now Update Sheet1 Set Response = Response + (Select Response from Sheet1 where question is null and id = id + 1); Sheet1 is the table name, Response is the column I want to update, id is the column with the ids in numeric orders. I am trying to update the response with the response column plus response column with two criteras. It should be the row below the question I want to update, hence the id + 1, and the question column of the response should be null which is the where question is null come from. Basically any response without a question should move one up and merge with the row above it. Problem is I am getting errors, so I am curious as to what did I do wrong. I am pretty newbie to SQL and I need to finish updating the damn thing by tomorrow, otherwise I will be burried by all the work I have to do. So any ideas?