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: 3738

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
My excel application only allows to import the queries written on single

Please provide VBA code to acheive this.



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:


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.