How can I combine a several cells of data into one cell?

Question

I need to combine several cells of data into one cell which will be exported to MS Excel from MS Access. The problem posed is there can be an unknown amount of cells to be combined from the MS Access data. Is there a way to run a script to combine the data into one cell before it is exported to Excel?

Answer 1

ok .. u will have to do a query in MS Access that will combine the columns for yaa and then export that to excle .. you could ither send it to me to do it for yaa or u can try to go with these steps ..
1. open the Access file u want to work on.
2. go to Quries.
3. New > design view > OK
4. choose the table u want to work on
5. add all the fields u need ..
6. As for the field u need to combine.. use this code (ex. firstname + " " + lastname)
and MS Access will do the rest for yaa
7. save the Query ..
8. open it now .. it should be the way u want it ..
9 . File > export

Good Luck
Salam