Create table from a crosstab query

J

Jon Maxim

I could like to create a link from an Excel table to a crosstab query.
Unfortuntaely Excell will only link to Access tables or select queries. How
can I get the data froma crosstab query into a table?
 
J

John W. Vinson

I could like to create a link from an Excel table to a crosstab query.
Unfortuntaely Excell will only link to Access tables or select queries. How
can I get the data froma crosstab query into a table?
Click to expand...

Base an Append query or a MakeTable query on the crosstab query.
 
D

Duane Hookom

Does your crosstab have criteria and/or Column Headings?
Could you share the SQL view?
 
Top