Export to Excel - combine multiple fields in one cell

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
 
T

Tom van Stiphout

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count unique occurrences in a list 10
Adding Cost Field to Appointment 0
Exporting chuncks 9
Export to Excel 3
Record output in queries 1
exporting report fields to spreadsheet 1
reference cells on one tab by value of cell on other tab 5
Export Calendar / Exception Data to Excel: 0

Top