Cross tab

[steven H]

I have an access database whos tables are based on an odbc connection to oracle tables. The structure of the oracle tables is such that in order to analyse them (in access) I need to form a crosstab query (in access) (over 150 columns and 250000 rows) this I can do (takes a while to run) I then want to save this query as a table in order to form the basis for further analysis and calculated columns to be added before ultimately analysing with excel - my thinking is that I need to export the crosstab as a txt file then reimport as a table however I have been running this export for the last 21/2 hours... I want to arrive at the result quicker, any ideas (I realise this work would be quicker at the oracle end however this is not possible at the mo)

Steven
This message was edited by steven H on 2003-01-17 07:44
This message was edited by steven H on 2003-01-17 08:06

 

[Lee Attlesey]

Hi steven H

I have a similar Access 97 dB in which I have linked a number of tables through ODBC.

I created an empty table to populate data from the linked tables using an append query. This does take a huge amount of time for me to run even for just 40,000-50,000 records.

I think this may be easier than extracting the data as a .txt file then re-importing it.

 

[steven H]

Thats a good point however I want to have the data based on the crosstab pretty sure I cannot append from a crosstab query on to a table.