Hi,
This looks like a uphill task for me. may be I could get some help in resolving or finding a work around.

The task is :

I have a table - Table with 100+ columns.
column1 column2 column3 ............... column100
A B C R

I have to create 1 record by concatenating all the columns togather.
This merged record needs to be written to a file.

O/P

A B C R

VBA is one option or write a select query. But it will very tiresome and time consuming to write up all the columns.
I will need to write a query or VBA because, I will taking a field from the user based on which the data will be pulled and written to the output file.
Is there some macro/module option to handle this.

I need all the values in the columns and columns should be in the same sequence and with their sizes as they are in the table.

Can anyone suggest any easy way to merge the columns into 1.
I cannot use 3rd party s/w.

Thanks in advance.
SJ.

Start here:

http://www.access-programmers.co.uk/forums/showthread.php?p=671226

Post back with any questions

>>> Can anyone suggest any easy way to merge the columns into 1. <<<

Ah, I just realized, by this statement you mean merge all the columns into one record, not one column, if that's the case, the solution I pointed you to above won't be much good in this instance.