Microsoft Accounting Express 2008 Database

Discussion in 'Application Software' started by STP_Martin, Mar 12, 2009.

  1. STP_Martin

    STP_Martin MDL Novice

    Mar 12, 2009
    2
    0
    0
    Hi

    I've just started using Microsoft Accounting Express 2008 and i was wondering where or how i could access the database tables which is attached to the program so i can extract data etc?

    Thanks in advance

    Martin
     
  2. HMonk

    HMonk MDL Addicted

    Nov 3, 2008
    612
    7
    30
    SQL Server

    Depending on what SQL versions you have installed (installed by MAE) the database files will be stored in a DATA directory.

    Try %Program Files%\Microsoft SQL Server\MSSQL.1\MSSQL\DATA

    By the way, Express 2009 is now available.

    Monk
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. STP_Martin

    STP_Martin MDL Novice

    Mar 12, 2009
    2
    0
    0
    Hi

    Thanks for the reply,

    I have found what seems to the data file but it has an file extension of .SBD and .SBL, is there a way to actually look at the data and use Excel to import it? I only have the SQL Server that was installed with the software which only has the configuration tools.

    Yea i saw there was 2009 but it seems that its for the US and i'm guessing it'll all be setup for the US market etc.

    Martin
     
  4. HMonk

    HMonk MDL Addicted

    Nov 3, 2008
    612
    7
    30
    #4 HMonk, Mar 12, 2009
    Last edited: Mar 12, 2009
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...