How to read the data from .accdt file using oledbconnection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to read the data\content of my .accdt and .accfl files using the
oledb provider of .net 2.0
i've used the below connection string...but it's throwing a unrecognized
database format error...
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Microsoft
Office\Templates\1033\Access\Issues.accdt;Persist Security Info=False;";

Which connectin string shud i specify....is there any otther alternative for
reading these type of files ....please do help me out????
 
Thanks for the reply,Tom
I've downloaded the driver...
but still i'm unable to connect to .accdt file thru oledb..

any other alternative
 
I haven't tried it, but I think you need to try connecting to a .accdb file,
not a template file (.accdt). Here is some information from the Access Blog
site regarding the new template format:

"Template files in Access 2007 are a totally new file format based on the
Open Packaging Convention .....Access's old template files used to be .mdb
files renamed with the .mdt extension, but now they are a completely new
format consisting of a hierarchy of zipped up XML and text files."

Reference
http://blogs.msdn.com/access/archive/2007/08/06/access-2007-template-accdt-files.aspx

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Back
Top