creating a pivot with external data source (from access)

D

dstiefe

I am able to copy the records of a table to a recordset...see below

know I'm wondering how i can up that in a pivot table? I've only written
code when the data resides in an excel sheet

Thank you

this is my code to get the dataset from Access...

Sub GetAccessData()
Dim sh As Worksheet

Set sh = Sheets("Sheet2")

Dim MyConnect As String

Dim MyRecordset As ADODB.Recordset

MyConnect = "Provider=Microsoft.ACE.OlEDB.12.0;" & _
"Data Source = C:\Dans_DB.accdb"

Set MyRecordset = New ADODB.Recordset

MyRecordset.Open "DMA", MyConnect, adOpenStatic, adLockReadOnly
 

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

pivot table with external data 1
ADODB Problem with transferring data from Excel to Access 1
Error Calling A subroutine from a User Defined Function (UDF) that 2
Synchronize Excel sheet with Access table 0
Export specific fields from access to Excel 0
SQL not importing records from ACCDB 2
export excel data to access table using ADO 0
Import multiple Access Queries 0

Top