hi
I have a lot of data in one column in access. I would like to have all this
data on the one column to be on one row. Tried to copy it to excel and
transpose but the data is too long to transpose. Any ideas. i have over 200k
rows and want to list it on one line. thanks.

t wrote:
>I have a lot of data in one column in access. I would like to have all this
>data on the one column to be on one row. Tried to copy it to excel and
>transpose but the data is too long to transpose. Any ideas. i have over 200k
>rows and want to list it on one line.


How do you expect to display "over 200k" of anything on one
line of any printer or monitor.

I have a feeling there is a lot more to whatever you are
trying to accomplish beyond what you posted.

--
Marsh
MVP [MS Access]

On Sun, 17 Jan 2010 08:23:01 -0800, t <(E-Mail Removed)> wrote:

>hi
>I have a lot of data in one column in access. I would like to have all this
>data on the one column to be on one row. Tried to copy it to excel and
>transpose but the data is too long to transpose. Any ideas. i have over 200k
>rows and want to list it on one line. thanks.

Well, you certainly can't, not in Access: a single record is limited to 4096
bytes and 255 fields.

As Marshall says, 200,000 of ANYTHING all on one row will exceed any monitor,
or any sheet of paper, or any human capacity to understand. I cannot imagine
what it is that you're getting at.

What is this data? What will you do when you have a million-byte long text
string (if each record takes an average of five bytes)?
--

John W. Vinson [MVP]

I will break it up manually to make it more manageable but still need to know
how to save data that is in access (in a colunmn)in a row format. I have
coordinates that I need to display in google maps. I figure if I have 20 or
so coordinates per one line. If someone could give me general instructions
on how I can use the excel type transpose option in access or vba, That would
be great. Thanks.

"Marshall Barton" wrote:

> t wrote:
> >I have a lot of data in one column in access. I would like to have all this
> >data on the one column to be on one row. Tried to copy it to excel and
> >transpose but the data is too long to transpose. Any ideas. i have over 200k
> >rows and want to list it on one line.
>
>
> How do you expect to display "over 200k" of anything on one
> line of any printer or monitor.
>
> I have a feeling there is a lot more to whatever you are
> trying to accomplish beyond what you posted.
>
> --
> Marsh
> MVP [MS Access]
> .
>

I fail to see why you think an odd transposing will help you
solve a problem.

If you need to interact with another program with chunks of
data in some kind of list style, then you should open a
recordset on the records, loop through however many records
and build the list using concatenation.
--
Marsh
MVP [MS Access]


t wrote:
>I will break it up manually to make it more manageable but still need to know
>how to save data that is in access (in a colunmn)in a row format. I have
>coordinates that I need to display in google maps. I figure if I have 20 or
>so coordinates per one line. If someone could give me general instructions
>on how I can use the excel type transpose option in access or vba, That would
>be great. Thanks.
>
>"Marshall Barton" wrote:
>
>> t wrote:
>> >I have a lot of data in one column in access. I would like to have all this
>> >data on the one column to be on one row. Tried to copy it to excel and
>> >transpose but the data is too long to transpose. Any ideas. i have over 200k
>> >rows and want to list it on one line.
>>
>>
>> How do you expect to display "over 200k" of anything on one
>> line of any printer or monitor.
>>
>> I have a feeling there is a lot more to whatever you are
>> trying to accomplish beyond what you posted.

On Sun, 17 Jan 2010 13:26:01 -0800, t <(E-Mail Removed)> wrote:

>I will break it up manually to make it more manageable but still need to know
>how to save data that is in access (in a colunmn)in a row format. I have
>coordinates that I need to display in google maps. I figure if I have 20 or
>so coordinates per one line. If someone could give me general instructions
>on how I can use the excel type transpose option in access or vba, That would
>be great. Thanks.

Well, if you don't want all 200,000 records in one line (as your original post
implied) it's not all that hard. An Excel TRANSPOSE applies to an Excel
spreadsheet... and an Access Table is not an Excel Spreadsheet.

But you can apply the VBA code at
http://www.mvps.org/access/modules/mdl0004.htm
to construct a single text string from a set of related records.
--

John W. Vinson [MVP]