Copy from Excel to Access

[gebobs]

You could have a calculation of some sort at the end of each row which concatenates all the rows with the separator of your choice.

Say you have the Bob, Jim, and Tom in Row 1, A through C:

=CONCATENATE(A1," ",B1," ",C1)

will return Bob Jim Tom. Alternatively, you can use the CHAR function to insert something other than a space or just type something else in quotes that suits you. You'll have to experiment with what pastes and doesn't.

[GMC Phil]

Ahh thanks,

I am copying rows from columns B, C, and, D but they go up to H with a table to the side of H which uses information going back over 600 rows to calculate things. I can't really add a column in without messing historical calculations up.

How can I get around this?

Thank you so much for your help.

Phil