+ Reply to Thread
Results 1 to 2 of 2

Connecting Excel with access 2007

  1. #1
    Forum Contributor vikas.bhandari's Avatar
    Join Date
    04-07-2006
    Location
    Delhi, India
    MS-Off Ver
    Office 2007 and 2010
    Posts
    303

    Connecting Excel with access 2007

    I just got the new office installed on my computer and facing some problems...My question is regarding Excel VBA and access. Earlier, in 2003 version, I was using the following driver for accessing Access through excel:

    con.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "data source =D:\reports\eds\reports.mdb"

    But now, in Access 2007 version Formats, the mdb extension is changed to accb. Can anyone please tell me that which Driver we need to download or use to make it work?

    Thanks,
    Vikas

  2. #2
    Registered User
    Join Date
    03-08-2007
    Location
    Brisbane, Australia
    Posts
    57
    this might help

    http://www.microsoft.com/downloads/d...displaylang=en

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1