In Access I have a large database with 7000+ records. I want to combine the
data in 6 columns in this. I could not find a way to do it in Access so
copied it to Excel. I can apparently merge cells in Excel (and using CHAR(10)
between fields which will make things very neat) but it does not tell me how
to merge complete columns in one go.
I am using Vista Home Premium and Office 2007.
Can anybody please tell me - step by step - how I can do this? Assuming it
is possible.
Many thanks.