Export to Excel - combine multiple fields in one cell

  • Follow


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
0
Reply Utf 1/11/2010 10:26:01 PM

On Mon, 11 Jan 2010 14:26:01 -0800, Bon
<Bon@discussions.microsoft.com> wrote:

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


>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
0
Reply Tom 1/12/2010 4:08:16 AM


1 Replies
529 Views

(page loaded in 0.046 seconds)

Similiar Articles:
















7/16/2012 3:38:29 AM


Reply: