| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking crosstab query from Access
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Linking crosstab query from Access
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 "Sebastian" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
| ComboBox Form for CrossTab Query filtering | Excel Programming | |||
| Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
| Problem with excel linking to Access query | Excel Programming | |||
| Linking a table in Access to a table in Excel using MS Query | Excel Programming | |||
Hybrid Mode
