column to row

T

t

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.
 
M

Marshall Barton

t said:
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.
 
J

John W. Vinson

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)?
 
T

t

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
 
M

Marshall Barton

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.
 
J

John W. Vinson

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.
 

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

Top