Append Data into Cell

[jo15765]

I am running ADO query in Excel to import some data and combine a few fields. I am iterating through each record in the table and then putting the outcome in a cell in excel. The problem I have is that I want ALL of the data from the table to be in cell A1, and each entry is overwriting the previous, how can I set it to append the data not overwrite?

[Tiolucas]

I think if you create a variable (ex: data1) of type string, you could make something like: data1= data1 & ADO Query data field, and go on until last field with a do while loop. Finaly range("cell oyou want").value=data1.