how open .Dat file in MS Access RRS feed

  • Question

  • User250444435 posted

    Hello All,

    I wan to edit Database file which is with .dat Extension.

    The Connection string use in Configuration file that is.

    <add name="TecsHomeConnectionString"
                connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=TecsHome.dat; Jet OLEDB:Database Password=fdsa"
                providerName="System.Data.OleDb" />

    I have TecsHome.dat file. I am opening it in MS Access using Passwored = fdsa but MS access prompting invalid Password

    how can i open it if the given password in connectionstring is not working.

    keep in mind i don't have source code. I just want to open .Dat Database file.

    Thursday, October 7, 2010 6:30 AM


  • User275991403 posted


    dat file only supports random access reading.And it doesn't open in msaccess or anyother software.Better way you write a code in VBA to export data from dat file to msaccess.

    Use this link:


    it   will help you.



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 11, 2010 10:21 AM