Reverse Fields and records?

[parham1975]

Is it possible to reverse the order of fields and records in Access?
That is can I have fields displayed up-down in a table rather than as
in the default view of left-right?

It would make it much easier for me to get some data from Excel to
Access if I could do this as the data is the 'wrong way around' in
Excel so to speak - there's also too much of it to copy and paste using
transpose. Thanks for any help!

[Tom van Stiphout]

On 27 Sep 2006 06:39:59 -0700, pa********@msn.com wrote:

No.
So write your own automation code to fill Excel just the way you want
to.
Or rethink the whole thing: if there is too much data for Transpose,
do you really think the user will want to see all that data? Perhaps
exporting aggregate data or a smaller sample would suffice.

-Tom.

>Is it possible to reverse the order of fields and records in Access?
That is can I have fields displayed up-down in a table rather than as
in the default view of left-right?

It would make it much easier for me to get some data from Excel to
Access if I could do this as the data is the 'wrong way around' in
Excel so to speak - there's also too much of it to copy and paste using
transpose. Thanks for any help!

[ManningFan]

Write a function that will do a TransferSpreadsheet into a table, read
the contents of that table into a 2-dimentional array, write the array
out to the final table reversing the components and then clear out the
TransferSpreadsheet table. It's really not that difficult.

And NO, I won't do it for you.

However, I echo the previous poster's sentiments when he said to make
sure you rdatabase/table is set up properly. this will save you
buttloads of aggrivation later on if you take a few days to design your
database properly.

pa********@msn.com wrote:

Is it possible to reverse the order of fields and records in Access?
That is can I have fields displayed up-down in a table rather than as
in the default view of left-right?

It would make it much easier for me to get some data from Excel to
Access if I could do this as the data is the 'wrong way around' in
Excel so to speak - there's also too much of it to copy and paste using
transpose. Thanks for any help!

[Steve]

Thanks for the replies. I will so some research on the methods you
mentioned as at the moment you could have been speaking in another
languague to me frankly..so some reasding required! Thanks again!
ManningFan wrote:

Write a function that will do a TransferSpreadsheet into a table, read
the contents of that table into a 2-dimentional array, write the array
out to the final table reversing the components and then clear out the
TransferSpreadsheet table. It's really not that difficult.

And NO, I won't do it for you.

However, I echo the previous poster's sentiments when he said to make
sure you rdatabase/table is set up properly. this will save you
buttloads of aggrivation later on if you take a few days to design your
database properly.

pa********@msn.com wrote:

Is it possible to reverse the order of fields and records in Access?
That is can I have fields displayed up-down in a table rather than as
in the default view of left-right?

It would make it much easier for me to get some data from Excel to
Access if I could do this as the data is the 'wrong way around' in
Excel so to speak - there's also too much of it to copy and paste using
transpose. Thanks for any help!