Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strsql As String

'MAIN PROC
cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.Open "path and file name", "admin", ""
cn.CursorLocation = adUseClient

strsql = "SELECT frOM statement'
rs.Open strsql, cn

ECT...


Regards,

Devin

"Preston" wrote:

Hi,
I have a database that was developed using access 2007 and is split into
front ends and one backend. One of the things that I am doing with the data
in the backend is making a pivot table in Excel 200x. I have done this
without any problems in Excel 2007 but I am having trouble doing it in Excel
2003. Can you please tell me how to connect to an accdb file from excel 2003
so that I can generate the pivot table I need?
Thank you,
Preston