Linking crosstab query from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Within Excel I can import regular queries from Access "Data-From Access" but
crosstab queries are not in a list of available queries.

Is this intentional ?

Sebastian

BTW:
Both Access and Excel are 2007
 
Hi,

I don't know if it is intentional, but there is an alternative way of doing
what you want.

You can use ADO to directly query the MS Access tables into an ADO
Recordset, then dump the data into the worksheet in one step using the
CopyFromrecordset method ...

HTH

Philip
 
You must log in or register to reply here.

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

Access #Error & Excel Pivot 0
Create table from a crosstab query 2
Link, drop link, relink 2
Import Data from Access query 8
How to calculate a Range from Row and Column count 4
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Excel Query Causes Access To Go Read-Only 2
Pivot-table versus crosstab queries 1

Back
Top