Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Problem importing data from Access | Excel Discussion (Misc queries) | |||
Importing Data from Access | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |