Create table from a crosstab query

  • Thread starter Thread starter Jon Maxim
  • Start date Start date
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?
 
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.
 
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
CrossTab Manipulation 4
Crosstab Date Range in Reports 3
Crosstab query 1

Back
Top