goldenvision
Registered User.
- Local time
- Today, 22:53
- Joined
- Oct 22, 2003
- Messages
- 49
Does anyone know how to create a table from the results of a crosstab query?
When I try to run a make table the pc crashes.
I select add table and point to my crosstab query, at which point the pc hangs and access shows as Not Responding.
What is the maximum number of records that Access can handle. This crosstab query is based on a table containing 5.1m records.
I can make the crosstab run (this gives me 300k+ rows and 21 columns) but if I try to export the data in anyway (make table, export to txt/csv, copy and paste) the pc hangs.
Any help would be much appreciated
When I try to run a make table the pc crashes.
I select add table and point to my crosstab query, at which point the pc hangs and access shows as Not Responding.
What is the maximum number of records that Access can handle. This crosstab query is based on a table containing 5.1m records.
I can make the crosstab run (this gives me 300k+ rows and 21 columns) but if I try to export the data in anyway (make table, export to txt/csv, copy and paste) the pc hangs.
Any help would be much appreciated
