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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
problem with crosstab query 1
Form based on crosstab query 1
Loosing fields when creating a crosstab from a table 1
Crosstab query 1
Access Crosstab to Table 2
Crosstab Date Range in Reports 3
Crosstab query 1

Top