Need help! Query to convert rows to cols and vice-versa

[xyz123]

Hi,
Here is a very challenging problem in ms access 2007 (at least for me
)
There is a 2 column table as:
Month| Title
-------------
JAN | A
JAN | B
JAN | C
FEB | D
FEB | E
MAR | F
APR | G
APR | H
MAY | I
MAY | J
MAY | K


Problem:
This table needs to be displayed as following "in an Access table or
an Access query":
JAN| FEB| MAR| APR| MAY
-----------------------------------
A | D | F | G | I
B | E | - | H | J
C | - | - | - | K
I'm able to write this output to an Excel spreadsheet, but i've tried
n number of ways to get the exact same output as above in Access, but
I've not got any success yet.
I really need help on this - not only because I'm struggling with
this problme but also because now I am more curious in knowing how
this can be done in Access.
If you have a solution that you can provide I will highly appreciate
your help!
Thanks in advance!

[ajetrumpet]

transposing like Excel is not possible. why not try import/export, after using excel's functionality??

[xyz123]

Thanks for your prompt response Adam! I appreciate it!
Actually, i also have to put a button on a switchboard which would perform all these operations and then I will show the result in an Access formatted report.

Is there a way to automatically import/export data from a spreadsheet through a button.

Thanks!

[ivancp]

Are you try this solution:

http://support.microsoft.com/kb/202176

[pkstormy]

Is there a way to automatically import/export data from a spreadsheet through a button. Thanks!

I have this code: https://www.accessforums.net/code-re...iles-9500.html

Which allows you to select a folder (graphically) and will then automatically import all xls files in that folder. You can change the code as needed (It's fairly simple code). There's also some other code posted for exporting.

[ajetrumpet]

Thanks for your prompt response Adam! I appreciate it!
Actually, i also have to put a button on a switchboard which would perform all these operations and then I will show the result in an Access formatted report.

Is there a way to automatically import/export data from a spreadsheet through a button.

Thanks!

hey bud,

I would suggest adopting the in-house coding method from Ivan's link. That's the best way to do it. Luckily for you, you can 'almost' copy it verbatim from the article and substitute your names in for it!

[weekend00]

hey bud,

I would suggest adopting the in-house coding method from Ivan's link. That's the best way to do it. Luckily for you, you can 'almost' copy it verbatim from the article and substitute your names in for it!

Ivan's link won't do it.

it's not a simple transpose. I think we need some VBA do approch it.