importing from Access & need to rotate data--can't transpose--HELP
 

I'm not sure if this is better posted here or in an Access board. I have
query in Access that I'd like to bring into Excel. There are only about a
dozen records, but each has roughly 750 fields (most are blank).

I actually WANT it transposed so that it is a dozen columns wide x 750 rows.
I'm familiar with the transpose function, but that won't work because it's
too many columns to get into Excel to begin with. I have it in a columnar
formatted report in Access now & it looks exactly like I want it, but when I
export it to Excel, it puts each record on a separate row.

importing from Access & need to rotate data--can't transpose--HELP
 

I would do the following:

1) Create the query in Access as you want it to appear in Excel. Save the
query.

2) Go to Excel, go to Data--Get External Data. Select the database option,
choose MS Access as the db, navigate to the Access db in question, select the
query you designed in step 1, and import. (This process can even be recorded
as a macro, attached to a button, so that you can import the data with the
click of a button.)

Does that help?

Dave
--
Brevity is the soul of wit.


"Jason" wrote:

I'm not sure if this is better posted here or in an Access board. I have
query in Access that I'd like to bring into Excel. There are only about a
dozen records, but each has roughly 750 fields (most are blank).

I actually WANT it transposed so that it is a dozen columns wide x 750 rows.
I'm familiar with the transpose function, but that won't work because it's
too many columns to get into Excel to begin with. I have it in a columnar
formatted report in Access now & it looks exactly like I want it, but when I
export it to Excel, it puts each record on a separate row.