Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Opening Crosstab Queries of Access in Excel

  Asked By: Bonni    Date: Nov 01    Category: MS Office    Views: 2195
  

How can I open crosstab queries of MS Access in Excel?
I have many crosstab queries in Access database which needs to be imported to
Excel.
My excel application only allows to import the queries written on single
table.

Please provide VBA code to acheive this.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Evelyn Hughes     Answered On: Nov 01

I like to open  an ADODB.Recordset and then use the
Range.CopyFromRecordset(rs) method.

If you look up the help info on CopyFromRecordset, it's rather flexible. You
might find the following article useful:

http://www.mvps.org/access/modules/mdl0035.htm

 
Didn't find what you were looking for? Find more on Opening Crosstab Queries of Access in Excel Or get search suggestion and latest updates.




Tagged: