locked
Connection String for Connectiong Access 2007 from Excel2007 RRS feed

  • Question

  • Could you please let me know the Connetction string for Connectiong Access 2007 from Excel2007

    In Excel2003 I was using some thing as follwoing

    FROM `C:\Cube\Yearly_DB`.APM_Yearly apmy;
     
    Source_DSN="DSN=MS Access Database;
    DBQ=C:\Cube\Yearly_DB.mdb;
    DefaultDir=C:\Cube;
    DriverId=25;FIL=MS Access;MaxBufferSize=2048;
    PageTimeout=5;";UseExistingFile=FALSE

    Tuesday, August 10, 2010 10:21 AM

Answers

  • Not sure how you are connecting from Excel (code?), but connection string examples are listed below (OLEDB):

    http://www.connectionstrings.com/access-2007

    If you are using ODBC it should look something like the following:

    Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb
    

     




    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, August 10, 2010 12:45 PM

All replies