Export to Excel - combine multiple fields in one cell

  • Thread starter Thread starter Bon
  • Start date Start date
B

Bon

Can anyone give me some help on export records to Excel please. I have a
table were each field is 254 chars and I have chopped up some data. I would
like to put it back together as I export it to Excel. Like this:

part1
part2
part3
part4
etc.

Export all into Cell 1

Thanks in advance!

Bonnie
 
On Mon, 11 Jan 2010 14:26:01 -0800, Bon

Rather than exporting a table, export a query. In this query you
concatenate the fields:
select part1 & part2 & part3 & part4 as AllParts
from myTable

-Tom.
Microsoft Access MVP
 
Back
Top