Uncrossing a Crosstab

[Newie]

Hi,

Is there a clever person who knows whether I can "uncross" the data on a Crosstab ?

I import an Excel sheet into Access as a Table but the data appears in a Crosstab format, as I want to append this data to another Table it obviously needs to be in single line format.

Does anyone know if there is a way of getting the Column Headings as Row data alongside the Row data already in the results ?

I had tried a Crosstab query but had a feeling it wouldn't work before I even finished it, the only other thing I can think of is a Macro with a series of Append queries linked to each of the Column Headings.

Thanks in advance........

Steve

 

[namliam]

the only other thing I can think of is a Macro with a series of Append queries linked to each of the Column Headings.

This pretty much or a little piece of VBA to "addapt" a single append query on the fly and execute it at the same time...

 

[redalert]

To be able answer this question we would need to see the data and to also know what the minimum requirements are in terms of adding data to the new table as you may lack data to complete each record.

 

[Newie]

Hi both,

Thanks for your responses, I'm not good at VBA (in fact I'm useless having been self-taught using only Queries) so have created a Macro with a series of of Update queries geared to each column, long-winded I know but once set up, does the job very quickly, just wondered whether there was a quicker way ?

Many thanks....

Steve

 

[redalert]

If what you have done does the job then just leave at that.

How much quicker do you need it to work?

True, there may be ways that are considered more appropriate but probably which involve using VBA which you admit to not being very good at yet.